Request an

or Call

01524 230 252

Adding New Suppliers In Bulk

This guide will take you through the process of adding new suppliers in bulk via spreadsheets in Cloud Commerce Pro, as well setting up cost prices on products in bulk.

For a guide on how to manually add a supplier, click here

1. Template

1. Template

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.

2. Populate

2. Populate

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

Save the spreadsheet and give it an easily identifiable name.

3. Admin Centre

3. Admin Centre

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”.

4. Supplier List

4. Supplier List

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.

5. File Handling

5. File Handling

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”.

6. Upload

6. Upload

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.

7. Import Suppliers

7. Import Suppliers

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

Click “Import Suppliers” to continue.

8. Import In Progress

8. Import In Progress

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.

9. Admin Centre

9. Admin Centre

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.

10. Product Range

10. Product Range

Click “Exports” from the product range page.

11. Product Exports

11. Product Exports

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.

12. Actions

12. Actions

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.

13. Spreadsheet

13. Spreadsheet

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.

14. Cost Price – Imports

14. Cost Price - Imports

Navigate back to the Product Range page.

Click “Imports” to continue.

15. Cost Price – Upload Spreadsheet

15. Cost Price - Upload Spreadsheet

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

16. Cost Price – Import Supplier Links

16. Cost Price - Import Supplier Links

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

Click “Import Supplier Links” to continue.

17. Cost Price – Using The Upload

17. Cost Price - Using The Upload

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.

18. Cost Price – Upload Complete

18. Cost Price - Upload Complete

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.

Generic Order Importer

By Admin | July 11, 2018

Importing Customer Details

By Admin | June 1, 2018

Exporting Customers

By Admin | June 1, 2018

Deleting Suppliers

By Admin | May 31, 2018

Quickly Add Purchase Order

By Admin | May 30, 2018

Packing Station Video

By Admin | May 23, 2018

Order Management Video

By Admin | May 23, 2018

Dispatching Orders Video

By Admin | May 23, 2018

Order Dispatch Video

By Admin | May 23, 2018

Repricing On Amazon Video

By Admin | May 22, 2018