This guide will take you through the process of listing products and ranges to Woo Commerce in bulk via spreadsheet using Cloud Commerce Pro.
For a guide on how to list products manually to Woo Commerce, click here.
1. Admin Centre
To get started you need to export a list of your products. It is always advised to work from a freshly exported list of products to ensure the information is fully up to date.
Click “Products” to continue.
2. Product Range List
Click “Exports” from the product range page.
3. Product Exports
Click “Export Products” from the product exports page.
4. Product Exports – In Progress
A new entry will show at the bottom of the list displaying the status of the export.
Update the progress of the export by clicking the refresh button as pictured above.
5. Product Exports – Complete
Complete will show under status when the export has completed.
1. Hover the mouse over “Actions” for more options.
2. Click “Download Spreadsheet”. Save the spreadsheet to a memorable location on your computer or find it in your downloads folder depending on your browser settings.
6. Exported Spreadsheet
Open the exported spreadsheet from your computer and it should look similar to the example above.
You can use this document to create a template for your upload. Start by copying the headers from the top row of the document. Move the cursor anywhere in row 1, press SHIFT+SPACE to select the whole row and CTRL+C to copy the headers.
Create a new blank spreadsheet (File > New) and paste the row at the top of it with CTRL+V.
Now you need to find the products or ranges you wish to add within your exported spreadsheet. Press CTRL+F to open the find window. You can search by anything unique to that product such as SKU or range name.
Copy and paste the products and ranges into the new spreadsheet in the same way you did the headers.
7. Editing Spreadsheet Data
You can edit details of the products on the spreadsheet at this point if needed such as price.
If you are uploading product ranges, ensure the headers are correct and end with “DRD” as this tells the system to display the listing with a dropdown menu to allow customers to select from different sizes or colours for example.
When you have all your products on the new spreadsheet configured how you need them, save the document in a memorable location with an easily recognisable file name.
8. Product Range
Navigate back to the product range page and click “Imports”.
9. Product Imports
From the product imports page click “Upload Spreadsheet”.
10. Product Imports – Upload Complete
When the upload is complete it will display at the bottom of the list.
Check the box under “Use” and scroll down for more options.
11. Product Imports – Follow The Steps
With your uploaded spreadsheet selected for use, you need to go through each of the following steps sequentially to pull specific bits of data for the system to populate your Woo Commerce listing. This is done to preserve the integrity of the data.
Start with Step 1 and click the button besides it, in this case “Import Options”. The box will change to show the status of the import. Once it changes from “queued” to “complete”, scroll back up to your spreadsheet upload and check the box for “use” once more.
Repeat this process for steps 1 to 8.
12. Product Imports – Continue The Steps
Once steps 1 to 8 have completed successfully, do the same for Step 13which is the final step, by clicking “Add To Channel”.
13. Product Imports – Add To Channel
After clicking “Add To Channel” a window will open with a list of available sales channels.
Click “Use” next to the channel you want to use, in this example Woo Commerce.
14. Product Imports – Import Complete
The status of the import will be displayed. Once this changes to “Complete”, your import is done and your listing will show on your Woo Commerce site.