Import & Export Overview

Import & Export Overview

Import & Export Overview

Go to Admin >Settings > Data

Import New Data

Importing new data means the data is NOT already in your dispensary. For example, if you are adding a NEW herb, premix formula or product, it will not exist in your dispensary. Items not appearing in your dispensary have no ID associated with it. Once you upload it for the first time, the system will assign an numbered ID to each item you upload. If you try to import new data into the existing data section, it will not work, because new data doesn’t have an ID, and the system will be looking for this ID. If you are getting errors, check to ensure you are uploading to “New Data”.

You can import the following New Data:

1.  Categories (product, herb and formula)
2.  Single Herbs
3.  Products
4.  Herb Products (Custom Products)
5.  Premix Formulas
6.  Inventory/Stock
7.  Suppliers’ Products

Update Existing Data

You can update existing data in your dispensary by first exporting the data into a CSV file, making changes to the file, and then importing it again.

There is a specific section for updating existing data. If you try to import existing data into the “new data” section it will be rejected. This is because these files will have column showing the item ID, and new data doesn’t have this ID, so the data will not match up.

You can import to update existing data for the following types of data:

1. Single Herbs
2. Products & Product Prices
3. Herb Products
4. Premix Formulas
5. Inventory/Stock Values
6. Suppliers
7. Ingredient Prices

Exporting Data

You can export data from your dispensary into CSV files.

Single Herb Ingredients
Premix Formulas
Products
Herb Products
Inventory
Formula Templates
Orders
Suppliers


    • Related Articles

    • Import Supplier Products

      Import Supplier Products Go to Admin > Settings > Data > Import New Data > Supplier Products Before you begin, contact each of your suppliers and ask them to send you a list of their products in Excel or CSV format. Most suppliers should have this ...
    • Export Data

      Export Data Go to Admin > Settings > Data > Export Click on the tab corresponding tab to export the data you want. Single Herb Ingredients Products Herb Products (custom products) Premix Formulas Inventory Formula Templates Orders Pricing Supplier ...
    • Import Categories

      Import Categories Go to Admin > Settings > Data > Import New Data > Categories You can import herb , formula, and product categories into your dispensary, but please remember that if you add the category to an import file, it will automatically add ...
    • Formula Settings Overview

      Custom Formula Settings Overview Go to Admin > Settings > Formula Global Settings As the owner or administrator of the dispensary, you are going to set global settings which will be applicable for every new practitioner registering at your ...
    • Import New Inventory

      Import New Inventory Go to Admin > Settings > Data > Import > New Data > Inventory Inventory is the stock levels you have of each herb, premix formula or product. It ONLY deals with how much you have of everything and tracks how you consume it. This ...