I need to import bundle products to J2Store.
I have them in an excel file at the moment. And I can prepare the list that will be imported.
When importing: the bundle information is stored in the
- table #_j2store_variants in the
- field params as JSON value like this:
{"product_css_class":"","bundleproduct":{"2":{"product_name":"Kaufm\u00e4nnische Lehrabschlusspr\u00fcfung \u2010 Pflichtf\u00e4cher Lehrbuch (sku: 010-001)","product_id":"1"},"3":{"product_name":"Kaufm\u00e4nnische Lehrabschlusspr\u00fcfung - Pflichtf\u00e4cher \u00dcbungsbuch (sku: 010-002)","product_id":"12"},"4":{"product_name":"Paket Schriftverkehr f\u00fcr Gesch\u00e4ftsprozesse (sku: 010-003)","product_id":"105"},"5":{"product_name":"B\u00fcrokaufmann\/-frau Fachinhalte Lehrbuch und \u00dcbungsbuch (sku: 030-001)","product_id":"6"}},"display_price_per_each":"0","price_per_each_unit_singular_label":"","price_per_each_unit_plural_label":""}
How should the import look like?
I have J2Store products that have up to 10 products in the bundle information.
Should I have one line per product with 10 columns. And if I have a value there, it should be stored as bundle information as JSON.
Would that work?
Thanks
Sigrid