This guide will walk you through the process of adding country of origin codes to your products in bulk using spreadsheets and Cloud Commerce Pro's Import / Export tool.

1. Admin Centre

To get started we need to generate a product export with which to work from.

Click the "Products" button from the Admin Centre menu.

2. Product Ranges

On the Product Ranges screen, click the "Exports" button at the top of the page.

3. Product Exports

To begin generating your product export, click the "Export Products" button. This compiles all of the information about your products as it currently exists in Cloud Commerce Pro, and puts them into a spreadsheet.

While it may be tempting to work from an old spreadsheet, it is best practice to generate a fresh one to ensure you are always working with the most current data.

Once your spreadsheet has generated, it will be added to the top of the list of available exports. Hover your mouse over the "Actions" menu next to your export to continue.

4. Download Spreadsheet

From the Actions menu, click "Download Spreadsheet". Save the spreadsheet to your device and give it a memorable name to ensure you don't confuse it with any similar spreadsheets you might be working on.

Once you have done that, open your spreadsheet in your preferred software, such as Microsoft Excel, Google Sheets or Libre Office Calc.

5. Product Export Spreadsheet

To save time when importing your spreadsheet back into Cloud Commerce Pro, you will want to find and copy the products you want to assign country codes to, along with all of the spreadsheet headers, before pasting them on to a blank spreadsheet. This will make the import process considerably faster and ensures no changes are made to products that you do not want to be altered.

If you have never added country codes to your products before, we are going to have to create a new column for them to be entered.

Look at your spreadsheet headers and scroll to the section where the headers begin with "VAR_". While the specific order of the VAR columns doesn't matter, I like to keep things tidy by adding new columns at the end. Right click the very top of the last VAR column and select "Insert Columns After" to add a new blank column.

6. New Column Header

Now that you have a fresh blank column, you can go ahead and add the appropriate header. Headers are extremely important for the Import / Export tool as they inform Cloud Commerce Pro as to what the data contained in the column will be used for.

The correct header for your new column should be:

VAR_Countryoforigin

Now you can assign any three letter country code to any of your products on the spreadsheet, such as GBR for Great Britain or FRA for France.

For a list of all of the recognised country codes, click the link below.

Once you are happy with the codes you have entered, save the spreadsheet on your device.

7. Return To Product Ranges

Head back Cloud Commerce Pro and the "Products" screen from earlier. At the top of the screen, click the "Imports" button.

8. Import Tool

Here we can upload our newly created spreadsheet with our column of country codes by clicking the "Upload Spreadsheet" button. This will add the new spreadsheet to the importer so we can use it to push that data out to your system in the form of an import.

Once your spreadsheet has been uploaded, it will appear at the top of the list of available items. Tick the box next to your new upload to tell Cloud Commerce Pro we will be using this particular spreadsheet for the importation process.

9. Begin The Import

Scroll down the page a bit to find the many different import steps that can be run. Luckily in this case only "Step 5" needs to be used.

Click the "Import Variations" button next to Step 5 to begin your import.

The information at the bottom of the step shows the progress of the import. Have patience if it is a little slow as the speed can vary depending on how many other imports are running through the system at any given time. The import details will show once everything is complete, and any errors will be displayed here so you can troubleshoot them easily.

Did this answer your question?