Instructions for bulk upload (with Multilanguage Support)

* This file supports multiple languages. When adding product information in different languages, you need to append "_en" (for English) or the respective locale code to the translatable fields.
* For example: 
  - name_en, short_description_en, description_en, meta_title_en, meta_description_en, estimated_delivery_text_en, return_policy_text_en

---


* You can keep fields blank which are optional
-------------------------------------------------------------------
Products Data
-------------------------------------------------------------------

1. name_en: (Required) Enter the name of the product. Maximum 255 characters allowed.

2. product_type: (Required) Specify the type of product. Choose from: 'physical', 'digital', 'external'.

3. description_en: (Required) Provide a detailed description of the product. Minimum 10 characters required.

4. short_description_en: (Required) Briefly describe the product in a few words.

5. type: (Required) Specify the product type. Choose from: 'simple', 'classified'.

6. price: (Required for 'simple' type) Enter the price of the product.

7. stock_status: (Required for 'simple' type) Specify the stock status as 'in_stock' or 'out_of_stock'.

8. quantity: (Required for 'simple' type) Enter the quantity of the product available in stock.

9. sku: (Required for 'simple' type) Unique Stock Keeping Unit (SKU) for the product.

10. discount: (Optional) Enter a numeric discount value in percentage (e.g., 10.5 for 10.5%). Maximum two decimal places allowed.

11. show_stock_quantity: (Optional) Set as '0' for inactive or '1' for active to display stock quantity.

12. is_featured: (Optional) Set as '0' for inactive or '1' for active to mark as a featured product.

13. secure_checkout: (Optional) Set as '0' for inactive or '1' for active to enable secure checkout.

14. safe_checkout: (Optional) Set as '0' for inactive or '1' for active to enable safe checkout.

15. social_share: (Optional) Set as '0' for inactive or '1' for active to enable social sharing.

16. encourage_order: (Optional) Set as '0' for inactive or '1' for active to encourage orders.

17. encourage_view: (Optional) Set as '0' for inactive or '1' for active to encourage views.

18. is_cod: (Optional) Set as '0' for inactive or '1' for active to enable Cash on Delivery (COD).

19. is_return: (Optional) Set as '0' for inactive or '1' for active to allow returns.

20. is_free_shipping: (Optional) Set as '0' for inactive or '1' for active to enable free shipping.

21. is_changeable: (Optional) Set as '0' for inactive or '1' for active to allow changes.

22. is_sale_enable: (Optional) Set as '0' for inactive or '1' for active to enable sales.

23. is_external: (Optional) Set as '0' for inactive or '1' for active if the product is external.

24. external_url: (Required if 'is_external' is '1') Provide the URL of the external product.

25. watermark: (Optional) Set as '0' for inactive or '1' for active to enable watermark.

26. watermark_position: (Required if 'watermark' is '1') Specify the position of the watermark.

27. is_licensable: (Required if 'product_type' is 'digital') Set as '0' for inactive or '1' for active to enable licensing.

28. is_licensekey_auto: (Required if 'is_licensable' is '1') Specify if the license key is auto-generated.

29. sale_starts_at: (Optional) Specify the start date of the sale (if applicable).

30. store_id: (Optional) Enter the ID of the store the product belongs to (if applicable).

31. brand_id: (Optional) Enter the ID of the brand the product belongs to (if applicable).

32. sale_expired_at: (Optional) Specify the expiration date of the sale (if applicable).

33. separator: (Required if 'license_key' is provided) Specify the separator used to separate license keys. Choose from: 'new_line', 'double_new_line', 'comma', 'semicolon', 'pipe'.

34. status: (Required) Set as '0' for inactive or '1' for active to determine the product's status.

35. visible_time: (Optional) Specify the visible time/date of the product.

36. variations: (Required if 'type' is 'classified') Provide variations for the classified product.

37. Publication_id: (Optional) Enter the ID of the publication the product belongs to (if applicable).

38. authors_id: (Optional) Enter the IDs of the authors the product belongs to (if applicable).

39. external_details: (Optional) Enter the external details the product belongs to (if applicable).

Instructions for Bulk Import - Categories, Attributes, and Tags

-------------------------------------------------------------------
Categories
-------------------------------------------------------------------

1. categories: (Required) Assign categories to products by providing their IDs separated by commas without spaces. For example: 1,2,3.

-------------------------------------------------------------------
Attributes
-------------------------------------------------------------------

2. attributes: (Required for 'classified' type) Attach attributes to products by specifying their IDs separated by commas without spaces. For instance: 4,5,6.

-------------------------------------------------------------------
Tags
-------------------------------------------------------------------

3. tags: (Optional) Associate tags with products using their IDs separated by commas without spaces. Example: 7,8,9.


-------------------------------------------------------------------
Product Images
-------------------------------------------------------------------

1. product_thumbnail_url: (Optional) Add the URL of the product's thumbnail image. Use 'http://' or 'https://' URLs only.

2. product_meta_image_url: (Optional) Provide the URL for the product's meta image. Ensure it starts with 'http://' or 'https://'.

3. size_chart_image_url: (Optional) Include the URL of the product's size chart image. URLs should start with 'http://' or 'https://'.


-------------------------------------------------------------------
Product Digital Files and Watermark Data
-------------------------------------------------------------------

1. preview_audio_file_url: (Optional) Provide the URL for the preview audio file. Ensure it's a valid audio file URL. Use 'http://' or 'https://' URLs only.

2. watermark_image_url: (Required if 'preview_audio_file_url' is provided) URL of the watermark image. Must be a valid image URL. Use 'http://' or 'https://' URLs only.

3. preview_video_file_url: (Optional) Specify the URL for the preview video file. Ensure it's a valid video file URL. Use 'http://' or 'https://' URLs only.

4. digital_files_url: (Optional) Provide a comma-separated list of URLs for digital files associated with the product. Each URL should point to a valid digital file. Use 'http://' or 'https://' URLs only.

5. watermark_position: (Optional) Specify the position of the watermark on the product images. Choose from available options: top-left, top, top-right, left, center, right, bottom-left, bottom, bottom-right.


-------------------------------------------------------------------
Wholesale Prices Data
-------------------------------------------------------------------

1. wholesale_prices: (Required) Provide an array of JSON objects, each representing a wholesale price tier. Each object should have the following keys:

    - min_qty: (Required) Minimum quantity for this price tier.
    - max_qty: (Required) Maximum quantity for this price tier.
    - value: (Required) Wholesale price value for this tier.

Example JSON format:

	[
	  {
	    "min_qty": 10,
	    "max_qty": 20,
	    "value": 25
	  },
	  {
	    "min_qty": 21,
	    "max_qty": 30,
	    "value": 22
	  }
	]



-------------------------------------------------------------------
Product Variations (JSON Format)
-------------------------------------------------------------------

1. Variations: Provide an array of JSON objects, each representing a product variation. Use the following structure for each variation:

   {
    "name_en": "Deliciously Sweet Watermelon 1 KG",
    "price": 6,
    "discount": 9,
    "stock_status": "in_stock",
    "sku": "FRUIT1KG08",
    "quantity": 2,
    "variation_image_url": "https://fastkart.webiots.co.in/storage/99/Watermelon_3.png",
    "digital_files_url": [
      "https://fastkart.webiots.co.in/storage/99/Watermelon_3.png",
      "https://fastkart.webiots.co.in/storage/99/Watermelon_3.png"
    ],
    "attribute_values": [
      1
    ],
    "is_licensable": 0,
    "is_licensekey_auto": 0,
    "license_key": "LicenseKey1,LicenseKey2",
    "separator": "comma",
    "status": 1
  }

	1. name_en: (Required) Enter the name of the product.

	2. price: (Required) Specify the price of the product.

	3. discount: (Optional) Provide a discount percentage for the product.

	4. stock_status: (Required) Specify the stock status as 'in_stock' or 'out_of_stock'.

	5. sku: (Required) Unique Stock Keeping Unit (SKU) for the product.

	6. quantity: (Required) Enter the quantity of the product available in stock.

	7. variation_image_url: (Required) URL of the variation image for the product.

	8. digital_files_url: (Optional) Provide an array of URLs for digital files associated with the product.

	9. attribute_values: (Required) Array containing attribute value IDs associated with the product.

	10. is_licensable: (Required) Set as '0' for products that are not licensable or '1' for licensable products.

	11. is_licensekey_auto: (Required if 'is_licensable' is '1') Specify if the license keys are auto-generated.

	12. license_key: (Required if 'is_licensable' is '1') Provide the license keys associated with the product. If multiple license keys are provided, separate them using the specified separator.

	13. separator: (Required if 'license_key' is provided) Specify the separator used to separate license keys. Choose from: 'new_line', 'double_new_line', 'comma', 'semicolon', 'pipe'.

	14. status: (Required) Set as '0' for inactive or '1' for active to determine the product's status.


   Example JSON format:

   [
  {
    "name_en": "Deliciously Sweet Watermelon 1 KG",
    "price": 6,
    "discount": 9,
    "stock_status": "in_stock",
    "sku": "FRUIT1KG08",
    "quantity": 2,
    "variation_image_url": "https://fastkart.webiots.co.in/storage/99/Watermelon_3.png",
    "digital_files_url": [
      "https://fastkart.webiots.co.in/storage/99/Watermelon_3.png",
      "https://fastkart.webiots.co.in/storage/99/Watermelon_3.png"
    ],
    "attribute_values": [
      1
    ],
    "is_licensable": 0,
    "is_licensekey_auto": 0,
    "license_key": "LicenseKey1,LicenseKey2",
    "separator": ",",
    "status": 1
  },
  {
    "name_en": "Deliciously Sweet Watermelon 5 KG",
    "price": 30,
    "discount": 8,
    "stock_status": "in_stock",
    "sku": "FRUIT5KG08",
    "quantity": 5,
    "variation_image_url": "https://fastkart.webiots.co.in/storage/99/Watermelon_5.png",
    "digital_files_url": [
      "https://fastkart.webiots.co.in/storage/100/digital_Watermelon_5.png",
      "https://fastkart.webiots.co.in/storage/100/digital_Watermelon_5.png"
    ],
    "attribute_values": [
      1
    ],
    "is_licensable": 0,
    "is_licensekey_auto": 0,
    "license_key": "DigiLicenseKey1,DigiLicenseKey1",
    "separator": ",",
    "status": 1
  }
]



