@extends('layouts.master') @section('page_title', 'Product Guideline') @section('title', 'Product Import Guideline') @section('main_item', 'Product Guideline') @section('sub_item', 'Product Guideline') @section('content')

Follow the instructions carefully before importing the file.

The columns of the files should be in the following order

Column No Column Name Instruction
1 Product Name (Required) * Column title should be "product_name".
* Name of the product.
2 Product Category (Required) * Column title should be "category".
* Name of the product category.
  (If not found, new category with the given name will be created.)
  (If you have more categories, separate them like this: Party Light | Vehicle Item)
3 Product Sub Category * Column title should be "sub_category".
* Name of the product sub category.
  (If not found, new sub category with the given name will be created.)
  (If you have one subcategorie, input them accordingly. For example, if the first category is 'fruit' then subcategories must be input like this:(apple))
  (If you have multiple subcategories, input them accordingly. For example, if the first category is 'fruit' and the second category is 'vegetable,' then subcategories must be input like this: (apple|orange), (carrot|cabbage))
4 Product Unit (Required) * Column title should be "unit".
* Name of the product unit.
  (If not found, new unit with the given name will be created.)
5 Product SKU * Column title should be "sku".
* Product SKU.
6 Product Reorder Level (Required) * Column title should be "reorder_level".
* Name of the product unit.
7 Product type (Required) * Column title should be "Product type".
* Available options: variable, single.
8 Variation * Column title should be "variation".
* Ex: Size,Color
  (If not found, new attribute with the given name will be created.)
9 Variation Values * Column title should be "variation_value".
* Values for the attributes should be separated with "|".
* Ex: (Red|Blue|Green),(small|large)
  (If not found, new variation value with the given name will be created.)
10 Second Variation * Column title should be "second_variation".
* Ex: Color,Size
  (If not found, new attribute with the given name will be created.)
11 Second Variation Value * Column title should be "second_variation_value".
* Product Second Variations Values.
12 Qty * Column title should be "qty".
* Product Quantities.
13 Unit Cost * Column title should be "unit_cost".
14 Unit Price * Column title should be "unit_price".
15 Warranty Type * Column title should be "warranty_type".
* Available options: month, year, day
16 Warranty Period * Column title should be "warranty_period".
* Ex: 2,5,4
17 Allow Woocommerce Sync * Column title should be "allow_woocommerce_sync".
* Available options: yes, no
18 Business location * Column title should be "Business location".
* Full Name of the Business location Name should be separated with "|".
* Ex: (Clicky IT Solution|Kids Boutiqueco)
19 Product Description * Column title should be "descrption".
* Product Description.
@endsection