You can upload a bulk list of rules into Cloud Cart Connector. The most common is a one to one mapping of SKUs, though you can upload a list of any rules.
If your product SKUs match your QuickBooks item names, then there is no need to create a mapping. Here is the QB name field:
Here is an example SKU:
Many customers use these spreadsheets if they have no SKUs or if their online store, like Amazon, generates SKUs different than the QuickBooks item names.
For more info on how Cloud Cart maps products, please read instructions.
Is it possible to split SKUs and take the left side only?
Instead of adding one to one mapping, you could say split SKUs in half. For instructions, read this guide.
Getting Started with SKU Mapping
Here are the steps:
- Login to cloudcartconnector.com.
- Go to the bulk upload page.
- Download the sample CSV.
- On the left column, enter the QuickBooks item name. On the right, enter the product SKU from your online store. If you are an Amazon customer, place the ASIN in the product SKU column.
- Upload the spreadsheet.