We work day in and out to come up with new and simplified features in KartRocket admin panel, here we are with a new product release a simplified version of “bulk product upload”.
Bulk product upload is such a trivial part of managing your website; we thought reducing the effort on this process would save a huge bunch of man hours. The existing 5 step process of bulk upload has been reduced to a single step, where you need to only specify important details and rest settings are set to default.
In the following article, we will explain you every minutest detail associated with the feature.
Please note that this is an add-on feature, the existing advanced bulk upload functionality is also there in the admin panel.
How the new bulk upload process works:
We’ve implemented the below changes in the existing advanced bulk upload process to make it more simple & user-friendly:
- Product import sheet has been recreated to include minimal required fields.
- Products are imported with default settings stated in the following part of the article.
Fields that can be imported:
- Product Name
- Meta Description
- Meta Keywords
- Meta Title
- Product Tags
- Subtract Stock
- Special Price
- Tax Class
- Sort order
- Product Status
Settings that can be defined:
- Import file: Here you can upload the csv file that you have created for basic bulk product import
- CSV Field Delimiter: Select the type of import file, you can select “,” or “Tab”
- Empty store before import: If you want to remove all the previously added products from admin, you can select Yes from the dropdown, else leave it as “No”
- New Items: You can select “Add” if you want to add new products that are not previously added, else you can “Skip” these
- Existing Items: You can select “Update” if you want to update the existing products, else you can “Skip” these
- Items In Store But Not In File: You can “Ignore / Delete / disable” the products that are available in the store but not included in the file that you are going to upload
- Identify Existing Products By Matching Field: You can define a unique identifier “SKU/Model” to identify existing products
Product Images Upload:
You can upload the product images in bulk by using Upload image functionality. Simply either click on Browse button and select image and upload or you can simply drag and drop images here.
Default settings & their values: Below is the list of the settings and their default values that we have set for the basic bulk import process.
|Setting Name||Definition||Default Value in Basic Bulk Product Import||Editable in Basic Bulk Product Import|
|Out of Stock||This is the status of the inventory in case product is sold out/out of stock||Out of Stock||No|
|Subtract Stock||This is the setting that allows user to set whether the inventory will be minus or not in case a product is sold.
This will be by default “Yes”, additionally, you can set this at product level by adding 1 for Yes and 0 for No in the basic bulk import sheet
|Requires Shipping||If you’re selling a digital download product or a service, requires shipping should be disabled, as nothing will be shipped to the customer.
This will be by default “Yes
|Minimum Quantity||This is the minimum quantity that a customer can purchase for a product||1||No|
|Product Status||This is the product status Enabled / Disabled
This will be by default “Enabled”, additionally you can set this at product level by adding 1 for Enabled and 0 for Disabled the product in basic bulk product import
|Weight Class||This will be “Kilogram” by default
|Length Class||This will be “Centimetres” by default||Centimetres||No|
|Customer Group||This is used in defining the special price of thee product. You can define that special price X will be available for a certain customer group.
This will be the default group that you have set in general settings, you can additionally set this at product level by adding customer group id in basic bulk product import
|Default Group defined in general settings||Yes|
Product import process is in general 2 steps process and these steps are:
I – To create excel sheet in the Kartrocket specified Format
We’ve specified format to upload products in bulk. Below is the attached upload sheet for basic bulk product sheet for your reference:
This sheet includes 2 worksheets, a.) Basic Import Sample sheet and b.) Import Sheet guide
- This worksheet i.e. “Import_Sheet_Guide” is created for reference, you can read the definition, Format to fill the values with examples.
- First worksheet “Basic_Import_Sample_Sheet” is a sample data sheet in Kartrocket format, you can edit/update the product data in the sheet.
- Please delete this worksheet i.e. “Import_Sheet_Guide” and upload only the first worksheet “Basic_Import_Sample_Sheet” after converting the sheet in Comma Delimited (CSV)/Tab Delimited (TXT) format.
- Please don’t change column names (column name’s format in case of attributes and options), else system will not accept the sheet.
- 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).
- Once all the values are filled the sheet is now ready for bulk import.
II – To upload excel sheet using Basic Bulk Product Import
- Login to your store admin panel
- Navigate to left side panel and click on “Catalog > Import products”
- A screen with the simplified fields for bulk import will open up. You can simply click on “Browse” to select the product file.
Note – If case you don’t have the new sheet format, Click on “Download Sample File” button
- Once the file has browsed and attached, go ahead and change the default values of the below fields as per your requirement.
- Then, click on “Import”
Note – The system will check the columns name for the predefined columns of the sample sheet and the sheet that is uploaded by the user. If the columns match, the upload process starts automatically, else it throws an error message that “Warning: Your headings are not suitable for direct usage please check every column has a unique heading and must be in specified format”.
- Once successfully imported, the products would be visible in the front end.
- For advanced upload features, you can click on “Advance Product Import” and the existing 5 step bulk import process would open up.
So, now you’re all set to use this feature in your day to day upload activity and decide when you want to go for the advanced import feature and when not.
We tried to make this article as useful as possible and I hope now you have the complete understanding of the feature. Watch out this space to be the first one to know about the product updates.
KartRocket has empowered 3000+ entrepreneurs, SMB’s and retailer with their online stores. It is not just a website builder platform, it’s an end to end eCommerce solution with all the features you require to create an online store, run & grow your online business.