Product and variant attribute index

 Column Name

             Description

               Input

Product Name (required)

Name of the product.

Eg: Almost famous tee.

Product Type

What kind of product is this.

Eg:T-shirt, mug etc.

Product Description

What makes it special.

Eg: 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.

Eg:Ts4You Clothing Wholesaler.

Supplier Code

Alpha-numeric code you attribute to this Supplier.

Ts4You-01

Brand

Brand of the product if applicable

Eg: Nike, Grohe

Tags

Tags you wish to associate with this product

Eg: 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 option within the category you mentioned in the Label column.

Note

You may fill in up to 3 options but NOT more than that.

For label, input info such as Size, Colour, Material etc.

For example, 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

Eg: Blue Linen Shirt (M)

Variant Description

Short description of the variant

Eg: Same idea as product description, fill in if needed.

Variant SKU (required)

Each SKU must be unique or an error will be generated

Eg: DCP021-XL

Barcode

Insert Barcode number if applicable.

Optional field.

Weight

Insert weight if you distinguish your products by weight.

Eg: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 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 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

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.

Eg: 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 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.