You to upload below fields using this bulk import option.
Product import process is in general 2 steps process and these steps are:
- Create excel sheet in the Kartrocket specified Format
Kartrocket has a specified format to upload products in bulk. You can download the sample file from Kartrocket dashboard.
Navigation: Catalog>Bulk Product Import
Click on Download Sample File button given on the Top right corner section to download the file.
Clicking on Download Sample File button will download a zip file which includes 2 files as mentioned below:
a) The pdf "Kartrocket_Guide_To_Create_Basic_Bulk_Product_Import_Sheet" is created for reference, you can read the definition, Format to fill the values with examples.
b) The second file is a worksheet "KartRocket_Sample_Basic_Products_Import" is a sample data sheet in Kartrocket format, you can edit/update the product data in the sheet.
d) Please don't change column names (column name's format in case of attributes), else system will not accept the sheet.
e) Please don't add / delete any column in the sheet, else system will not accept the sheet. In case you don't want to fill values in any column, please leave it blank (column name will be available as it is mentioned in the sheet).
f) If you want to update already uploaded products with simple bulk product import, fill in all the columns with updated/existing values. If you leave any column/value blank in the sheet and update the products, it will update the product with zero/default value. If you want to update products with selected columns, please use Advance Bulk Product Import (this option is not available in all plans).
g) Once all the values are filled the sheet is ready for bulk import.
2. To upload excel sheet using Basic Bulk Product Import
Please follow below mentioned steps to complete the basic bulk product import process:
a) Login to the admin panel
b) Go to Catalog > Import Products in left menu
3. These are the settings that you need to save;
Import File: Upload CSV/TXT file using Choose File field that you have saved in your local machine.
CSV Field Delimiter: In case of comma separated file please select “,” else in case of Txt please select “Tab”
Empty Store Before Import: If you want to empty the store i.e. delete all the products that are already available in the admin panel, please select “Yes”, else “No”
New Items: If you want to add new items in the admin, please select “Add”, else select “Skip” if you don’t want to add new products
Existing Items: If you want to update existing products with the details that are already filled in the sheet, please select “Update” else system will skip it
Items in Store but not in File: Here are 3 actions that you can perform on the items that are already available in the store but not added in the basic bulk product import sheet.
Ignore- If you don’t want to make any changes in data of previously added items
Delete- If you want to delete the items that are already available in the store
Disable- If you want to disable the items that are already available in the store
Identify Existing Product By Matching Fields: If you want to match this by SKU please select “SKU” field else please select “Model”
Import Images: You can browse images from media gallery, if the images are not available, please drag images from your machine and drop on the dropbox. Please find below screen shot for reference:
Fields default values:
Out of Stock Status- This will be “Out of Stock”
Subtract Stock- This will be by default “Yes”
Requires Shipping- This will be by default “Yes
Minimum Quantity- This will be “1”
Product Status- This will be “Enabled”
Weight Class- This will be “Kilogram”
Length Class-This will be “cms”
Tax Class- This will be “none”
Customer Group- This will be “default”
Add Categories to Top Bar- This will be “Yes”
Bottom Category Only- This will be “All Categories”
Category Delimiter- This will be “>”
Download Remote Images- This will be “No”