⚝
One Hat Cyber Team
⚝
Your IP:
216.73.217.108
Server IP:
97.74.83.112
Server:
Linux 112.83.74.97.host.secureserver.net 5.14.0-611.54.6.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Fri May 15 04:23:18 EDT 2026 x86_64
Server Software:
Apache
PHP Version:
8.2.31
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
home
/
trinadezambia
/
public_html
/
ecommerce
/
uploads
/
View File Name :
bulk-update-instructions.txt
Instructions for bulk update * Data till column AJ is for product rest for product variant(s) * You can update more variants by repeating variants data in sequence for ex. in sample file first row have 1 variant and second product have no any variants * You can keep fields blank if you don't want to change ------------------------------------------------------------------- products data ------------------------------------------------------------------- 1. product id - ID of the product which you want to update. You can find from manage products section - mandatory 2. category id - You can find from categories section 3. tax - You can find from products >> tax section 4. product type - It must be simple_product or variable_product 5. stock type - If you don't want stock management leave it blank. else Case 1 - if product type is simple_product it must be 0 (Stock will be managed product wise) Case 2 - if product type is variable_product and you want to manage stock product wise stock type should be 1 Case 3 - if product type is variable_product and you want to manage stock variant wise stock type should be 2 6. name - Name of the product 7. short description - Short descriotion about product 8. indicator - 0 -> none | 1 -> veg | 2 -> non-veg 9. cod allowed - 0 if COD not allowed - 1 if COD allowed - (default will be 1) 10. minimum order quantity - (default will be 1) 11. quantity step size - (default will be 1) 12. total allowed quantity 13. is prices inclusive tax - 0 if prices are not inclusive tax - 1 if prices are inclusive tax - (default will be 0) 14. is returnable - 0 if product is not returnable - 1 if product is returnable - (default will be 0) 15. is cancelable - 0 if product is not cancelable - 1 if product is cancelable - (default will be 0) 16. cancelable till - It must be received, processed or shipped (case sensitive) if product is cancelable otherwise leave it blank 17. image - You can copy relative path from media section - (for ex. uploads/media/2021/07.jpg) 18. video type - It must be youtube or vimeo(case sensitive) 19. video - Video link 20. tags - It must be comma separated for ex. TV,AC,Cooler etc. 21. warranty period - For ex. 6 months 22. guarantee period - For ex. 1 year 23. made in 24. sku - set it if stock type is 0 or 1 25. stock - set it if stock type is 0 or 1 26. availability - set it if stock type is 0 -> 0 - not available 1 - available 27. description - long description about product 28. deliverable_type - add one of the following value as required to your product. "0" - for product is not ready to delivarable in zipcodes which are in Database. "1" - for product is delivarable in all zipcodes which are in Database. "2" - for product is delivarable in these included zipcodes which are in Database. "3" - for product is delivarable except this zipcodes which are in Database. 29. deliverable_zipcodes - List as per the above option(Deliverable_Type) you selected. And it should be comma separated like 1,2,3 30. deliverable_city_type - add one of the following value as required to your product. - mandatory "0" - for product is not ready to delivarable in cities which are in Database. "1" - for product is delivarable in all cities which are in Database. "2" - for product is delivarable in these included cities which are in Database. "3" - for product is delivarable except this cities which are in Database. 31. deliverable_cities - List as per the above option(Deliverable_city_type) you selected. And it should be comma separated like 1,2,3 - mandatory 32. seller_id - Set Seller ID 33. brand - add brand of your database which you want to add it in that product - mandatory 34. hsn_code - add your product hsn_code - mandatory 35. pickup_location - add your pickup_location ( you can find it in your panel -> pickup location ) - mandatory 36. extra_description - add extra description of your product - mandatory ------------------------------------------------------------------- variants data ------------------------------------------------------------------- 37. variant id - ID of the product which you want to update. You can find from your database product variants table - mandatory 38. price - Price of the product. it must be greater than special price 39. special price - Discounted price of the product. it must be smaller than price - default will be 0 means no discounted price 40. sku - set it if stock type is 2 41. stock - set it if stock type is 2 42. images - You can copy relative path from media section. in case of multiple images paths must be separated with ,(comma) - optional (for ex. uploads/media/2021/07.jpg,uploads/media/2021/07.jpg) 43. availability - set it if stock type(depends on column 32.stock) is 2 -> 0 - not available 1 - available - optional 44. weight - weight of your product - mandatory 45. height - height of your product - mandatory 46. breadth - breadth of your product - mandatory 47. length - length of your product - mandatory