@extends("admin.layouts.sellermaster") @section('title','Import Product |') @section("body")
Import Products
Download Example For xls/csv File
{{ csrf_field() }}
@if ($errors->has('file')) {{ $errors->first('file') }} @endif

Instructions

Follow the instructions carefully before importing the file.

The columns of the file should be in the following order.

Column No Column Name Description
1 Category (Required) Name of category
2 Subcategory (Required) Name of subcategory
3 Childcategory (Optional) Name of childcategory
4 Store Name (Required) Name of your store (Must created before importing).
5 Brand Name (Required) Name of your brand
6 Product Name (Required) Name of your product
7 Product Description (Optional) Detail of your product
8 Model (Optional) Model No. of your product
9 SKU (Optional) Detail of your product
10 Price In (Required) Your Product price in currency (eg. INR,USD)
11 Price (Required) Your Product price [Note: Price must entered in this format eg. 50000 (No comma and character).]
12 Offer Price [Note: Leave blank if you dont want offer price.] Your Product offer price [Note: Price must entered in this format eg. 50000 (No comma and character).]
13 Featured (Optional)

Enable or disable product is featured or not.

(Yes = 1, No = 0)
14 Status (Required)

Enable or disable product is active or not.

(Yes = 1, No = 0)
15 Tax (Required if your price is exclusive of tax)

Enable tax class name (must created before enter name here) which you created in tax classes section or else enter 0.
16 Cash on delivery (Required)

Enable cash on delivery on your product.

(Yes = 1, No = 0)
17 Free Shipping (Required)

Enable free shipping on your product.

(Yes = 1, No = 0)
18 Return Available (Required)

Enable Return available on your product.

(Yes = 1, No = 0)
19 Cancel Available (Required)

Enable Cancel available on your product.

(Yes = 1, No = 0)
20 Selling Start at (Optional)

Enable if you want to start selling your product from specific date.

(Date Format : 2019-11-12 00:00:00)
21 Warranty In (Period) (Optional)

Enter if your product have warranty else enter None.

(eg. 1)
22 Warranty in (months,year,days) (Optional)

Enable if your product have warranty else enter None.

(Available format: days,year,months)
23 Warranty type (Optional)

Enable if your product have warranty else enter None.

(Available types: Gurrantey, Warrantey)
24 Return Policy (Required if) If you set return available = 1, than enter return policy od (must created before entering id here). You can find return policies ids from here Click to view
25 Tax Rate (Required if) If you set tax = 0 and your price is inclusive of tax , than enter Tax rate

eg.(18,25)
26 Tax name (Required if) If you set tax = 0 and your price is inclusive of tax than enter your tax name.
27 Tags (Optional) Enter product tags by putting comma to seprate tags.
{{__("Download example for xls/csv File")}}
@csrf
@if ($errors->has('file')) {{ $errors->first('file') }} @endif

Instructions

Follow the instructions carefully before importing the file.

The columns of the file should be in the following order.

# Column Name Required Description
1. product_name Yes Name of your product.
2. key_features No Key features of your product ( HTML tags can also be put).
2. product_details Yes Description of your product ( HTML tags can also be put).
3. category_id Yes Name of your category
4. subcategory_id Yes Name of your subcategory
5. child_id No Name of your childcategory
6. product_tags No Seperate your product tag by putting comma.
7. tax_rate Yes Enter your tax rate without % sign.
8. tax_name Yes Name your tax.
9. thumbnail Yes Name your thumbnail image eg: thumbnail.jpg (Image must be already put in public/images/simple_products) folder ) .
10. hover_thumbnail Yes Name your hover thumbnail image eg: hover_thumbnail.jpg (Image must be already put in public/images/simple_products) folder ) .
11. status Yes For Active Product put 1 for deactive put 0.
12. store_id Yes Name of your store.
13. brand_id Yes Name of your brand.
14. type Yes Type of your product.
  • For Simple Product put type simple_product
  • For Digital Product put type d_product
  • For External Product put type ex_product
15. free_shipping Yes If product have free_shipping put 1 else put 0.
16. featured Yes If product is featured put 1 else put 0.
17. cancel_avbl Yes If product have cancellation enable put 1 else put 0.
18. cod_avbl Yes If product have COD enable put 1 else put 0.
19. return_avbl Yes If product have Return enable put 1 else put 0.
20. return_policy Required if If you set return_avbl = 1, than enter return policy id (must created before entering id here). You can find return policies ids from here Click to view
21. model_no Model NO. Enter your product model no.
22. sku SKU Enter your product sku.
23. hsin Yes Enter your product HSIN NO.
24. actual_offer_price NO Enter your product offer price without tax else put 0.
25. actual_price Yes Enter your product price without tax.
26. stock Yes Enter your product stock or put 0.
27. min_order_qty Yes Enter your product minimum order quantity.
28. max_order_qty NO Enter your product maximum order quantity.
29. external_product_link NO If Product type is set to ex_product then put your external product link in this column else leave it blank.
@endsection