Import/Export Errors & Fixes

Import/Export Errors & Fixes

Import Fixes

We have documented the common errors that you may face when you upload a products in bulk using our Import/Export tools. Browse below for the errors and fixes.

Error 1: Invalid Header

Solution: You'll get invalid header errors mostly when there is a mismatch between the type how you call the Attributes or/and Attribute Group or/and Option Values or/and Attributes Group.

For example: In the bulk excel sheet that you import, if the Attribute Group is called as Name, then in the backend setting(Tools > Import/Export > Settings), this field 'Use attribute_group_id instead of attribute_group name in worksheet 'ProductAttributes' should be unticked. If you are importing the sheet with Attribute Group ID and NOT by Group Name, then this field should be checked.

Same is the case with other fields where you may get error i.e., Option Values, Option Group or Attribute values.

To simply understand, a student in a class will have two unique identification properties i.e., Name and Roll Number. If a student database in a system is having the header as Roll_Number, then only the Student's Roll Number should be entered and NOT Student Name. Hence this is more like a configuration setting rather than an error. 

Error 2: Product_ID Missing

This happens when there is a no product_id mentioned in the main 'Products' sheet but exists in any other sheets/tabs like ProductAttributes sheet or ProductOptions sheet, for instance.

Solution: Find a Product_ID which exists in any of the sheets, but not in the 'Products' sheets. If you don't need those Products to be imported, either remove those product_id rows from the other sheets or add that product_id details in the 'Products' sheet.

Error 3: Invisible Formatting Added

Sometimes MS-Excel adds invisible formatting to the empty rows and or columns.

Solution: Hard-Delete the empty rows and columns and import again. You can do hard-delete by selecting all the empty rows together, and in the left hand side, do a right click and click on delete. This not just delete the content in the empty rows, if any, but delete the entire rows and any invisible formatting applied. Do the same for the empty columns too and upload again.

Last Resolution

We understand that sometime it would be annoying importing products in bulk, but it's mostly some common errors we make which you will figure out when you keep working with the system regularly.

In rare cases, when you are not able to import the sheets at all, we recommend you to 'export' some of the existing products and just change the data there without doing any other change. This should work 100%.



Export Fixes

There is no bugs found in Export options. However since we load your site with a lot of products and data, PHP will throw a memory limit issue. This issue can be sorted just by exporting 50 products at a time by entering From and To product id range in the respective fields.

What is Product_ID

It's just the Product_ID numbers that you'll see in every rows of the products sheets. If you are not sure where to check it from, you can visit our one-page-for-all-the-products at https://baapstore.com/hidn4paydsellers2.

How to find the Product_IDs ranges of the respective products

2. Under 'System Formatted Sheets' tab, download the respective category of products' sheets which you want to edit/work on. You'll find a header named 'Product_ID' which is the product id of those respective products.
3. Enter the Product_ID in the 'Start' and 'End' range while exporting using the Import/Export tool which will export only the selected range.
    • Related Articles

    • How to Bulk Update Stocks Quantity in Amazon Marketplace?

      We have created a simple method that should take you approximately 1-2 minutes every day to sync our stocks in your Amazon account. Please follow the below steps: Step 1: Download the Excel Sheet "Amazon_Bulk_Stock_Update_Template" from this link: ...
    • How to Export/Import the Products?

      How to Export the products Step 1: Login to your admin account dashboard using your username and password. Step 2: From the left pane, click on Tools > Export / Import' as in the below image. Step 3: In the right side 'Export / Import' window, under ...
    • How to Bulk change my Products Pricing?

      You can set your own pricing following our picture tutorial below. Note: It's very simple to change the product pricing, we made it look lengthy because to show you each step one by one. Just doing it once or twice, you'll find it simple. Try it now. ...
    • How to Upload & Update Stocks on Shopify (By Products)

      We have made the uploading of the products and updating stock-outs on Shopify a breeze. Just follow the below steps: Log on to your reseller panel at reseller.baapstore.com and click on the 'Smart Export Tool' from the top menu. Click on 'Daily Sync ...
    • How to Provide Discounts Based on Customer Groups

      To do it manually, please follow the below steps: 1. Login to your Admin dashboard 2. Navigate to Catalog > Products 3. Click on 'Edit' button against whichever product you want to edit. 4. Under 'Discount' tab, select the customer group you want and ...