Import New Simple Products
Go to Admin > Settings > Data > Select New Data > Select Simple Products in the drop down
What is a Simple Product?
For Information on the different Product Types, click here
Do you Want to Update Existing Simple Products?
If you want to update your existing product information, click Here for step by step instructions.
Where do I add prices for my product?
Simple Product Import does not include the price of the product. Your first step is to import the information about your product, and then you can update the prices. We keep prices and product data separated!
For instructions on how to add prices to Simple Products, click here.
Steps to Import NEW Simple Products
There are only 5 mandatory fields, the rest are optional
Download the Blank Product CSV file and open it up in excel
Products support multiple product names in different languages. You need to add at least ONE product name in any column. If you want to add more product names that is ok. (Columns E to R)
Copy one product name to the “Default Product Name” column. Even if you have only one product name, you still need to specify the default product name. (Column A). The default product name must match a product name exactly.
Enter a SKU#. If you do not have one, make one up. It needs to be unique per product. You can also use the same SKU# as your supplier if you have that available. (Column C)
Enter the Product Status. The only Possible values are Published, Pending Review & Draft. (Column B)
Enter a Product Category in Column V for every product in your file. If the category doesn’t exist in your dispensary it will be automatically created when you import.
Copy the product category column to the Default Product Category column. (Column D)
Upload File
You can now upload your file.
Go to Admin > Settings > Data > Import > Select New Data> Choose Simple Products from the dropdown.
Browser for your file and press “Review”
The system will make sure your information is correct and formatted properly.
Problems will be highlighted and shown to you at the top of the page. If there is a problem, you can reject the upload, fix the issues and try again.
Having Problems?
If you are having problems formatting your import files, please reach out to us and we can help you.
List of All Fields in Simple Product CSV/Excel File
Default Product Name
Product Status
Product SKU#
Default Product Category
English Name
Other English Name
Latin Name
Other Latin Name
Pinyin Name
Other Pinyin Name
Chinese Name
Other Chinese Name
Korean Name
Other Korean Name
Japanese Name
Other Japanese Name
Sanskrit Name
Other Sanskrit Name
Description
Family
Species
Categories
TCM Channels
Flavour
Temperature
Cautions and Contraindications
Associated Allopathic Conditions
Associated Allopathic Conditions Sources
Symptoms
Symptoms Sources
Possible Drug Interactions
Possible Drug Interactions Sources
Tags
Part of Plant
Process Type
Contains Aristolochic Acid
Contains Gluten
External Use
Toxic
Ratio Left
Ratio Right
Glycerin Percentage
Alcohol Percentage
Caution with Pregnancy
Organic
Alcohol Type
Kosher
Wildcrafted
Contains Corn
Contains Egg
Contains Animal Products
Contains Wheat
Contains Fish
Contains Soy
Contains Artificial Sweetners
Contains Peanuts
Contains Milk
Contains Shellfish
Contains Treenuts
Vegan
Contains Cholesterol
GMO-Free
Contains Mustard
Contains Sesame
Contains Nuts
Made in a Peanut free facility
Contains Sulphites
Granule Filler
Properties
Images
Show out of stock to Users
Users can purchase when out of stock
Re-Order Level
Default Supplier Id
Product Notes
Taxable