1. stefankarp
  2. RO CSVI
  3. Thursday, 27 December 2018
  4.  Subscribe via email
Hi,

we have been using "Fast Seller" and I basically want to create a csv file that contains the 'product_id' and the product properties set with "fast seller".

Ideally something like that:

[table]
[tr]
[td]sku[/td]
[td]productType[/td]
[td]productTypeProperties[/td]
[/tr]
[tr]
[td]s0001[/td]
[td]Food[/td]
[td]Color:Green|Color:Red|Type:Fruit|Tags:Healthy[/td]
[/tr]
[tr]
[td]s0002[/td]
[td]Games[/td]
[td]Color:Blue|Color:Red|Type:Cards|Tags:Fun|Age:9+[/td]
[/tr]
[/table]

(I want to try to export the Virtuemart / Fast Seller Data into a different store that runs on shopware).

I can work with an export of the tables directly from the database and try my best with excel / libre office, but if I could create a file that is closer to this directly with csvi it would be even better. I couldn't add the required fields in a vm_product export and the fast_seller export profiles don't seem to help either.

I attached the reference import / export file of the ideal export file (from the official documentation: https://docs.shopware.com/en/shopware-5-en/import-export/import-export-article#properties). I image others might have run into a similar issue, but I couldn't find any information on that.

The VM Shop currently runs on Joomla 3.7/VM 3.0.8 with CSVI Pro 7.10.0.
Accepted Answer Pending Moderation
Hello Stefan,

As you probably found out is that CSVI doesn't export the Fastseller data as such. CSVI exports the productTypeProperties as individual columns. You can see an example of this in the Import Product type names tutorial at the bottom.

The product_sku and productType isn't a problem, that is exported as in your example. I don't know if your Shopware can work with the columns approach, otherwise you will have to create an Excel formula that merges these columns together.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month 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!