1. deadlydave
  2. RO CSVI
  3. Tuesday, 15 May 2018
  4.  Subscribe via email
is it possible to enable importing of 0 values?

My clients have product sheets and they occasionally remove information they want to not display.
Accepted Answer Pending Moderation
Hello,
Importing 0 values for which field? Can you explain a bit more on this?
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
we use a custom product feed for our custom system.

so we have

product_sku, price_title_1, price_title_2, price_title_3,

SKU1234, printed 1 colour, printed 2 colours, printed 3 colours

however if someone imports the above and then tries to remove one of those columns by providing a zero or missing value it just ignores it.

product_sku price_title_1, price_title_2, price_title_3,

SKU1234 printed 1 colour, , 0

so say the product is no longer available with a 2 or 3 colour print they can't update it.
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
You can use CSVI Skip rule plugin to create a rule which checks for values for your fields and if they are 0 the row is skipped on import.
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
Accepted Answer Pending Moderation
Hello,
I read your message wrong at first. Reading it again made me understand that you are not able to update values 0 to custom fields. I was able to see the same issue and have fixed it with the attached patch file. Can you load the patch file and run the import again?

patch_vm_2018_05_17.zip
Attachments (1)
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. # 4
  • Page :
  • 1


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