1. keep
  2. RO CSVI
  3. Friday, 10 March 2023
  4.  Subscribe via email
Hello
Is it possible to import a file for VirtueMart Product Prices with the following structure?
SKU;Shopper group1;Price1;Shopper group2;Price2;Shopper group3;Price3

The main goal would be to keep one line per product
Accepted Answer Pending Moderation
Hello,
Multiple prices should be imported in multiple lines using VirtueMart price import template. RO CSVI does not support one product with multiple prices in one row.
Kind regards,

Tharuna

=========================
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
Accepted Answer Pending Moderation
Okay thanks.
So here is a more developer-based question.
I have PHP skills, made several plugins for Joomla/VM.
As far as I can see, there are plugin triggers in RO CSVI, like onBeforeImport
Is it possible to create a script which runs after the source is loaded but before the import.
The idea would be to fetch the data with the structure I wrote above and convert to the correct format via the plugin.
Like the source is
SKU;Shopper group1;Price1;Shopper group2;Price2;Shopper group3;Price3
and the onBeforeImport converts it to
SKU;Shopper group1;Price1
SKU;Shopper group2;Price2
SKU;Shopper group3;Price3

I know there are rule plugins but I think it can't be done with the existing ones.
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
Is it possible to create a script which runs after the source is loaded but before the import.

This will be a hack in RO CSVI core and not possible with custom plugins. I would recommend to write independent custom script to read the CSV and convert into needed format and save as new CSV file before running the import. You can write it as a bash script where each command is a line on its own. So the first line will be your custom script and saves the new file on your server. RO CSVI price import runs next and reads the file from the location saved on your server. You can setup a cron job to execute the bash script.

I know there are rule plugins but I think it can't be done with the existing ones.

Yes existing rule plugins do not support this feature.
Kind regards,

Tharuna

=========================
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. # 3
  • Page :
  • 1


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