How do I create and update products in Big com from a spreadsheet all at the same time?

Hi @RahulGupta!

Can I double check that you’re using Google Sheets and not Excel? You’ve included Google Sheets as a tag and your screenshot shows Google Sheets so I think that’s what you’re using but I wanted to double check. 

If you want to pass all of the information from a Google Sheet to Big Commerce at the same time, you can use a Transfer. A Zap runs each time something happens, for example when you add or update a row on a Google Sheet. With Transfer, you can move lots of data at the same time. You can either have a Transfer run once or you can run it on a schedule, for example once a week transfer will go through all of the data in the sheet. 

​I hope that's clear, please let us know if you have any questions!

Hi @Danvers, I’m using Google Sheets as the trigger.

I tried Transfer  but there are limited options not for  Product Creation

Is there any way, which helps run My Zap at a specific date or time with all the data from Sheet 

Actually, I’m using a code tool to update and Create New products 

Python request, which gets the data from the sheet and creates or Update the Product

this is running fine but I want to Run this process at a specific time or date like every week or day

Thanks for the extra information @RahulGupta

If you’d like the Zap to run on a specific day of the week, Schedule is perfect for that. If Schedule is the trigger, you’ll need to add another step in the Zap to pull any relevant rows from Google Sheets that will be used in the rest of the Zap. 

Looking at Transfer, you can use a it with a webhook step, ie use Google Sheets as the data sources and then add a Webhook step. If using schedule doesn’t work, you could create a Zap with a Catch Hook trigger and use the Google Sheet information to trigger that hook and send the relevant information to the rest of the Zap.

Would either of those options work for you? Let us know if not and we can keep brainstorming with you :) 

Thanks for your support @Danvers :)