How to create multiple orders in Baselinker or WooCommerce from Google Sheets using Zapier

Hi ​@Kamkachuliganka 

Help us have more info by posting screenshots showing how your Zap steps are outlined and configured in EDIT mode with the field mappings visible.

Provide more info about what steps are you stuck on.

Hi ​@Troy Tessalone 

Thank you so much for your response and help. I would really appreciate your assistance!

I am a new Zapier user and do not fully understand all the rules of how it works. I tried to set this up with ChatGPT, but it often suggests solutions that don’t exist. 😅 Unfortunately, there is no official documentation for Baselinker.

I am sharing access to my Google Drive folder – inside, you will find a google sheets file containing orders “Orders to Baselinker” as well as screenshots of my individual steps and test results. The screenshots are of good quality, so the long ones can be zoomed in without any issues.

I know that I need to add some action between steps 2 and 3 because the order is being treated as one instead of three separate orders. However, despite watching many tutorials and using Formatter and other tools, I just can't figure it out. I should also mention that English is not my native language 🤡

The final effect in Baselinker and WooCommerce is the same. I receive one order for "Frank Frank Frank Debbie Debbie Debbie", etc., which includes all the products from the Orders to Baselinker file.

Again, I truly appreciate any help you can offer!

Anyone? 🙄 I’m stucked 😭

Hi ​@Kamkachuliganka,

I just came across your post here and wanted to check in here to see how you’re getting on. Were you able to resolve the issue here?

Please do let us know if you’re still in need of some help on this at all - happy to assist further! 🙂

Unfortunately I am still waiting for someone to help me ☹️

Hi ​@Kamkachuliganka,

To automate order grouping in Baselinker or WooCommerce via Zapier, start with a Google Sheets trigger for new or updated rows. Then, use "Get Many Spreadsheet Rows" to fetch all rows sharing the same order number. Convert these rows into a structured text string with Formatter by Zapier's "Line-item to Text" action. Finally, use the "Create Order" action in Baselinker or WooCommerce to generate an order with all items. Adjustments may be needed based on your spreadsheet structure, so providing more details can help refine the workflow.

I hope this helps, and please let me know if you have any other questions or need further clarification.

To create multiple orders in Baselinker or WooCommerce from Google Sheets using Zapier, follow these steps:

1. Connect Google Sheets: Create a Zap and choose Google Sheets as the trigger app. Set it to trigger when a new row is added or updated.

2. Set up WooCommerce/Baselinker: For the action app, select WooCommerce or Baselinker and choose the "Create Order" action.

3. Map fields: Map the required columns from your Google Sheets to the fields in the WooCommerce/Baselinker order form, such as customer details, product, and quantity.

4. Test and activate: Test your Zap and activate it to automate the order creation process.