Categories
View Replies (7)

Resolved use margin plugin with prices that have a comma [solved]

  1. delinieict
    delinieict
  2. RO CSVI
  3. Sunday, 16 April 2017
  4.  Subscribe via email
Hi, having a bit of a challenge importing a price that is written with a comma like 6,56 and combining it with the margin plugin.

Found out that the margin plugin is only using the number in front of the comma when adding a margin of 25% and giving 7,50 as result in stead of 8,20.
When I change the comma to a point it works as expected.
But because the file is delevered "as is" the change have to be made within CSVi.

So I thought about a replacement plugin/rule to first replace the , with a . and then do the margin rule but for some reason this is nog working out for me.

The question is: should it be able to work like I described or am I looking for a solution in the wrong place or just doing it wrong ? ;)
0
Responses (7)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
So I thought about a replacement plugin/rule to first replace the , with a . and then do the margin rule but for some reason this is nog working out for me.

Can you post on screenshot on how you have set up the replace rule and margin rule? Also the screenshot of the template field where the rule is applied to.
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
delinieict
delinieict
Accepted Answer Pending Moderation
Hi Tharuna,

Sure I can.
margin.jpg replace-dot.jpg template-field.jpg

Thanks for checking.
Nico
Attachments (3)
margin.jpg margin.jpg
replace-dot.jpg replace-dot.jpg
template-field.jpg template-field.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Nico,
Your rule settings looks good to me. Can you please post your template XML file and sample import file to check?. To get template XML file go to CSVI maintenance page, Select CSVI Pro on first option and Backup template on second option. Select your template and click continue. Download the XML file and post it.
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
delinieict
delinieict
Accepted Answer Pending Moderation
Here they are :
Attachments (2)
csvi_templates_20170417.xml
import.csv
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Nico,
Thank you for sending the requested files. I have modified margin plugin core code to replace comma with a period so we can avoid replace rule. The code changes is attached as a patch file here. Can you try to load the attached patch file and check on your import? You can remove the replace rule applied on the product_msrp field.

plugin_margin_2017_04_17.zip
Attachments (1)
plugin_margin_2017_04_17.zip
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. # 5
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Nico,
I have done little more modifications to the margin plugin and have attached the modified patch file. Please check and confirm margin rule with this modified file.

plugin_modified.zip
Attachments (1)
plugin_modified.zip
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. # 6
delinieict
delinieict
Accepted Answer Pending Moderation
Hi Tharuna,

This is working great now, thanks for the help in sorting this !

Nico
  1. more than a month ago
  2. RO CSVI
  3. # 7
  • Page :
  • 1


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