Import New Product with Variants
Go to Admin > Settings > Data > Import > New Data > Product with Variants
Step 1 - Add Product
Step 1 – Important
You cannot just add a new product with variants in one step. It requires 2 steps. First add the product as a simple product without variants
To add a product with variants, you first need to add the product as a simple product without variants before completing this upload. The purpose of this upload is to add variants to a simple product that has no variants or to add variants to a product that already has at least one variant.
Step 1 - Add Variants to the Simple Product
The following fields are ALL required for this upload.
Product Id
SKU
Product Name
Variant Name
Manual Cost of Goods
Price Type
Amount
Product ID
The Product ID entered into this upload is the product ID of the simple product that has already been added in step 1. To obtain this ID you can edit the Product Record by going to Admin > Products > Edit Product or Export your Simple Products if you are uploading a lot of products with variants at one time as the first method will take a long time with a lot of products.
SKU#
Each variant of the product will require a SKU#. If you do not have one, you can create one but you cannot leave it blank.
Product Name
The product Name should be copied from the product that was already created in step 1.
Variant Name
The variant name is the actual variant, such as Small, Medium, Large, or Yellow, Green or Blue etc. The variant should exist already in your dispensary. You can add new variants by going to Admin > Settings > Product Settings > Simple Products > Variant List
Manual Cost of Goods
Enter the Manual Cost of Goods which is what you pay for the product. Only enter the actual number, no $ is required.
Price Type
Enter the Price Type which can be one of the following. (copy exactly)
exactPrice
margin
fixed
markuppercentage
“ExactPrice” will sell the product as the exact price you enter into the “Amount” column. No $ sign is required.
“margin” will calculate the selling price based on the margin you want to make, and is calculated based on the cost of goods you enter. No % sign is required.
“fixed” amount will add a specific amount to the manual cost of goods, which will be your selling price. (cost of goods + fixed amount = selling price) No n$ sign is required.
“markuppercentage’ will multiply your manual cost of goods by a specific percentage to determine the final selling price of the variant product. No % sign is required.
($50.00 cost of goods multiplied by 100% = $100.00 selling price)
NOTE: When entering values into any upload, only enter the actual numbers, no special characters like a $ or % sign is required, the system knows the purpose of the value