cancel
Showing results for 
Search instead for 
Did you mean: 

Configurable product bulk upload via csv in Magento 2

Configurable product bulk upload via csv in Magento 2

Hi, I'm trying to upload around 500+ products (1 configurable, 500+ simple) in bulk via csv in magento 2. Its a configurable product which has 4 custom attributes. The problem is that since I'm uploading 500+ products, the value for configurable_variations does not fit the cell in my csv file. 

 

This is how my configurable_variations cell look like for 2 products:

sku=prod1_sku,attrib1=value,attrib2=value,attrib3=value,attrib4=value|sku=prod2_sku,attrib1=value,attrib2=value,attrib3=value,attrib4=value

 

For 500+ products it contains around 70,000 characters which exceeds the cell limit in excel which is 32,767 characters. Is there a workaround for this in magento2? I really don't wanna do batch upload. Any help would be appreciated.

1 REPLY 1

Re: Configurable product bulk upload via csv in Magento 2

If you're looking for some alternative product import tools I've had some success with Scott'sBolasevich's import extension for Magento 1 and he seems to have one available for Magento 2 now: https://www.commerceextensions.com/magento-product-import-export-magento-2.html

----
If you've found one of my answers useful, please give "Kudos" or "Accept as Solution" as appropriate. Thanks!