1. seagul
  2. RO CSVI
  3. Wednesday, 21 May 2025
  4.  Subscribe via email
Hi,
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
Accepted Answer Pending Moderation
Hello Sigrid,
As of now we do not support import of bundled products in J2Store. There is a good news. I have developed this feature and attached it as a patch file here.

To get this feature you need to
1. Load the attached patch file
2. Run update of available fields
3. Create J2Store Variants import template.
4. You can then add bundled products using bundled_product_name and bundled_product_sku fields. These fields can be imported along with other fields.


A sample CSV file would look like


sku,bundled_product_name,bundled_product_sku
Bundled_product,Product 1~Product 2,Product_1sku~Product_2sku


Try the import and let me know on how it goes.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 1 day ago
  2. RO CSVI
  3. # 1
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!