When bulk importing or updating products or variants using CSV files, there are numerous attributes that can be edited.
Here's a list of each attribute with a description of their use within QuickBooks Commerce.
Column Name |
Description |
Input |
Product Name (required) |
Name of the product |
E.g.: Almost famous tee. |
Product Type |
What kind of product this is |
E.g.: T-shirt, mug, skirt, etc. |
Product Description |
Information about its features, benefits and more |
E.g.: Athletes have won more championships and medals with the Sneaky A Frame more than with any other single sport product on earth. |
Supplier |
Who is your wholesaler? This has to match the name of an existing relationship. |
E.g.: Ts4You Clothing Wholesaler. |
Supplier Code |
Alpha-numeric code you attribute to this Supplier. |
E.g.: Ts4You-01 |
Brand |
Brand of the product (if applicable) |
E.g.: Nike, Grohe |
Tags |
Tags you wish to associate with this product |
E.g.: Sports, Cutlery, Gift |
Option 1 Label |
Label - Refers to the categories you can distinguish the products by. This value is required if you are importing products with variants. This column is required if you are importing products with variants. Value - Refers to the different options within the category you mentioned in the Label column. Note You may fill in up to 3 options but NOT more than that. |
For labels, input info such as Size, Colour, Material, etc. For instance, an option label ‘Size’, will see option values such as Small, Medium, Large. In another example, the option label ‘Color’ will see option values such as yellow, blue, red. |
Option 1 Value |
||
Option 2 Label |
||
Option 2 Value |
||
Option 3 Label |
||
Option 3 Value |
||
Variant Name (required) |
Insert Variant Name |
E.g.: Blue Linen Shirt (M) |
Variant Description |
Short description of the variant |
E.g.: Same idea as product description, fill in if needed. |
Variant SKU (required) |
Each SKU must be unique or an error will be generated |
E.g.: DCP021-XL |
Barcode |
Insert Barcode number if applicable. |
Optional field. |
Weight |
Insert weight if you distinguish your products by weight. |
E.g.:100g |
Wholesale Price |
This is determined by your base currency and price list. |
Insert the price without the $ sign. |
Retail Price |
This is determined by your base currency and price list. |
Insert the price without the $ sign. |
Buy Price |
This is determined by your base currency and price list. |
Insert the price without the $ sign. |
Initial Cost Price (ICP) per unit |
ICP and stock go hand in hand, it is the most important column in the whole spreadsheet. ICP is based on the stock you currently have.What you put here as your ICP is what your MAC will be at this point. Note ICP cannot be changed after this point. |
Insert the price without the $ sign. |
Initial Stock Level |
Your ICP is dependant on whether you have stock. This means that if you have stock, you will have an ICP. If you don’t, you can leave it blank along with the ICP column. |
Put in the numerical value of a stock. For example, if you have ten shirts, insert 10 here. |
Taxable |
Whether this product is taxable or not |
Indicate TRUE or FALSE. |
Manage Stock |
Activates the keep selling function. If you click TRUE it will allow you to keep selling past zero. If you click FALSE you will not be able to keep selling once your stock level has reached zero. |
Indicate TRUE or FALSE. |
Keep Selling |
Allows items to be sold even if they're out of stock on your online channels |
Indicate TRUE or FALSE. |
Publish Online |
*It only works for Woocommerce. Note If you wish to publish products from your Shopify or Magento stores add column(s) and fill in the name of the store(s) in the header. Each store must have a separate column such as Shopify 1 and Shopify 2. |
Fill in TRUE or FALSE accordingly. |
Private B2B e-Commerce Portal |
This is for our customers using our Private B2B e-Commerce Portal |
Indicate TRUE or FALSE. |
Batch Tracked |
Ability to create unique batches that can be tracked independently of one another in warehouses, perform recalls quickly, and ensure older products are sold first. Note: Once you have assigned stock to a batch number within a product, you will no longer be able to disable the batch tracked toggle for that product. |
Indicate TRUE or FALSE. |
Optional Additional Columns- You can create these if required. |
||
Max_online |
The amount of stock that you wish to display as available on your eCommerce store. |
E.g.: You may have ten cups but only wish to display five as available, the number to insert here would be 5. |
Sellable |
If the variant or product is sellable or not. |
Indicate TRUE or FALSE. |
Country of Origin |
The country of origin of the product. |
US, GB, AU, etc. Only alpha 2 country codes are accepted. Has to be in capitals. |
HS Code |
Harmonized System code. This is an international nomenclature (at a 6-digit level) developed by the World Customs Organisation for the classification of goods. |
123456 - The minimum is 6 digits. |
Position |
Within this column, number your variants according to the order in which you would like to view them in your inventory. |
Eg: If you have three sizes, S, M & L and you would like them to be displayed in that order, then S would have a corresponding value of 1, M would be 2 and L would be 3. |