Note: Upon .csv import, the recipe will not be updated if the product already exists in the database.


Download the sample products file, edit the products and upload (Details here)


Consider the definition of a Hamburger as a composite product.

Let us say the Hamburger is made of:

  • Buns - 2.0 Nos
  • Patty - 1.0 Nos
  • Onions - 0.1 pounds
  • Lettuce - 0.04 pounds
  • Tomatoes - 0.1 pounds
  • Ham - 0.505 pounds
  • Cheese - 1 slice

Step 1. Define ingredients as products in the .csv file (refer Table 1.1 & the attached sample .csv file). For" section_name", use names such as "Raw materials" or "Ingredients" for clarity. Make sure the "measure_type" column is correct.


Step 2. Define the composite product. Column U to AZ (.csv file) of a product`s definition is for ingredients of the product (refer Table 1.1 & the attached sample .csv file). "Composite_product_name" indicates the name of the ingredient & "Composite_product_quantity" indicates the quantity of the ingredient in the same unit as mentioned in the ingredient definition.


Table 1.1 - mandatory fields for defining composite products


Column Required Type Description Example
name Yes string Item Name Hamburger
section_name Yes
string
Section name
If you want the item to be listed within the category, you can provide the category name.
If section name is empty it will add to General section.

Note: If you provide a new section name which does not exist, the system will automatically add the new Section.
Burgers
selling_price Yes float
Selling base price ( Unit amount excluding tax, discount ).

Positive value (Price > 0)
Decimal places: 2
Decimal separator: point (not comma)
No currency symbol

Note: If 0.00 is submitted here, the import will break at that point.
3.99
discount_percentage No

Discount percentage

Positive value (Percentage > 0 and less than 99.00)
Decimal places: 2
Decimal separator: point (not comma)
No percentage symbol

Note: If discount is greater than 99 is submitted here, the import will break at that point.
6.00
tax_name Yes
string Tax name
Provide the tax name which you have already added.

Note: If you provide New Tax name which does not exist the system will automatically add the new Tax.
Sales_tax
tax_percentage Yes

Tax percentage
Note: If you provide tax name which already exists percentage tax  entry not required.

Positive value (Price > 0)
Decimal places: 2
Decimal separator: point (not comma)
No percentage symbol

Note: If you provide new tax name in the above column percentage is mandatory else it will take 0.00 (Zero).
7.05
enabled
Yes
string
Enabled 

yes = product is enabled
no   = product is disabled
Choose whether the Product should be enabled or not
yes
composite_product_1_name  Yes string     Buns
composite_product_1_quantity  Yes string    2.0
composite_product_2_name  Yes string     Patty
composite_product_2_quantity  Yes string
   1.0
composite_product_3_name
 Yes string
  Onions 
composite_product_3_quantity  Yes string
   0.1
composite_product_4_name
 Yes string
  Lettuce
composite_product_4_quantity  Yes string
   0.04
composite_product_5_name
 Yes string
  Tomatoes
composite_product_5_quantity  Yes string
   0.1
composite_product_6_name  Yes  string    Ham
composite_product_6_quantity   Yes string     0.505
composite_product_7_name  Yes string    Cheese
composite_product_7_quantity  Yes string     1.0

Step 3. Select the Stores to which these products need to be added. Click Import from CSV.

27-05-2016 13-33-17.jpg

Step 4. In your Shoptree account, click Products on Navigation bar & select Sections from the dropdown.



Step 5. Click on the sections which are used for ingredients (ex: "Raw materials", "ingredients" etc)


Step 6. Choose "Disabled" in the Status field

sectionedit.jpg

(Note: File Import can be done only for Standard Products. Maximum file size allowed is 5Mb)