The following steps will take you through this process. Please also see how to manually add a supplier here.

To start off, we need to create a template for adding our suppliers. Open Microsoft Excel and create a new spreadsheet with the 10 headers as pictured above.

It is a good idea to save the document at this point, so you can re-use it in the future as a template.

Populate the document with the relevant information about your suppliers, like the example above.

Save the spreadsheet and give it an easily identifiable name.

Once you have compiled your data into a spreadsheet and saved it, you can upload it to Cloud Commerce Pro.

From the admin centre, click “Suppliers”.

A list of any previously created suppliers will be shown. If this is your first time here, then the page will be blank.

Click “Imports” to continue.

From the file handling page, click “Upload Spreadsheet”.

A window will appear allowing you to browse your computer. Find the spreadsheet you created in the previous steps and click “Open”.

Your upload will automatically appear amongst the other files previously uploaded. They are listed alphabetically to make it easier to identify the one you need. The date and time of the upload are also shown, which can help narrow the search.

Tick the box under “Use” next to the file you uploaded.

Scroll down the page until you reach “Step 10: Suppliers (Incl. Addresses) import results”.

Click “Import Suppliers” to continue.

The information under Step 10 will change to reflect the status of the import. When the status changes from “Queued” to “Complete” the import has completed successfully.

Troubleshooting:

If an error displays after importing, it can often be because of information in the spreadsheet that wasn’t expected. If this is the case, copy the information in the spreadsheet including the headers, but being careful not to select any empty cells. Paste this into a new spreadsheet, save it, and repeat steps 5 to 8.

After you have imported your supplier details, you need to update and link cost prices to various products.

To get started, you will need to export a list of your products.

Click “Products” from the admin centre to continue.

Click “Exports” from the product range page.

1. Click “Export Products” to begin the export.

2. Your export will appear at the bottom of the list. The status column will show when it is ready to be viewed.

3. Hover the mouse over “Actions” for more options.

Click “Download Spreadsheet” to continue. Depending on your browser, this will either get sent to your preferred downloads folder or you will be prompted to choose a location.

Search the downloaded spreadsheet for the products you want to add cost prices to. You can either copy them over to a new spreadsheet or delete the products you do not need. Just ensure you have all the headers from the original export.

Populate the columns for VAR_CostPrice_ (N) with the cost price for each item and VAR_Supplier (O) with the name of the supplier you wish to assign to it.

Save the spreadsheet as something you will easily recognise.

Navigate back to the Product Range page.

Click “Imports” to continue.

Click “Upload Spreadsheet”. Navigate to the spreadsheet you saved in the previous step and click “Open”.

Scroll down the page until you reach “Step 11: Supplier Links import results”.

Click “Import Supplier Links” to continue.

Your upload will automatically appear amongst the other files previously uploaded. They are listed alphabetically to make it easier to identify the one you need. The date and time of the upload are also shown, which can help narrow the search.

Tick the box under “Use” next to the file you uploaded.

The information under Step 11 will change to reflect the status of the import. When the status changes from “Queued” to “Complete” the import has completed successfully.

Troubleshooting:

If an error displays after importing, it can often be because of information in the spreadsheet that wasn’t expected. If this is the case, copy the information in the spreadsheet including the headers, but being careful not to select any empty cells. Paste this into a new spreadsheet, save it, and repeat steps 15 to 18.