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.