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:
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.
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