1. slumley
  2. RO CSVI
  3. Tuesday, 22 September 2020
  4.  Subscribe via email
Hi,

As we are using CSVI to update stock quantities for products, we have added a Conditional rule to only list items greater than 5.
This works great, But we need to add another rule to do the following when we run the same process as explained above.
We need to be able to publish the product if the stock quantity is greater than 5.

Please can you assist in how we would be able to do this?

Regards
Stan
Accepted Answer
Accepted Answer Pending Moderation
Hello Stan,
The error attached in your screenshot shows there is an invalid entry in your database with virtuemart_product_id as 0. When you run the import with your file, there is another row inserted with virtuemart_product_id as 0 and that causes Duplicate entry error. I can see this query in the debug log you posted.


INSERT INTO `jos_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES (0, '2020-09-23-10-36-52405207712')


In your import template on File tab set Skip first line to Yes, save the template and run the import. See if the import finishes without an error.
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. # Permalink
Accepted Answer Pending Moderation
Hello Stan,
For publishing products which has stock quantity more than 5 you can create RO CSVI Skip rule plugin which would skip the rows which has stock quantity as 0,1,2,3,4. You need to set this as Value field in skip rule(see attached screenshot). This will skip the records which has stock quantity matching any of these values and will update records for stock quantity value 5 and above. You need to apply this rule on published field in your import template.

Let me know on that goes.
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. # 1
Accepted Answer Pending Moderation
Hi,

Thanks for your reply, I think I understand the rule.

We are confused about the Publishing the product part.

1: We have added the Published field to our template (See Pic: CSVI.jpg)

2: Can we Publish a product without there being a "Published" column in the CSV file, as we have tested this and it does not react? (See Pic:CSVI-1.jpg)
We can get products to be"Published if we add the field to the CSV file but we do not want to do this as this is the reason we use the field Mapper, so that we do not have to edit the stock files our suppliers send us.

3: step 2 would then be to apply the rule.

Regards
Stan
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello Stan,
1: We have added the Published field to our template (See Pic: CSVI.jpg)

This is correct.

2: Can we Publish a product without there being a "Published" column in the CSV file, as we have tested this and it does not react? (See Pic:CSVI-1.jpg)
We can get products to be"Published if we add the field to the CSV file but we do not want to do this as this is the reason we use the field Mapper, so that we do not have to edit the stock files our suppliers send us.

You should set Use file for configuration field on File tab to No in template settings. If this is set to Yes, RO CSVI will use the headers from import file. If this setting is set to No, RO CSVI will use the template fields as headers. Post the import debug log so i can check on this. To get the debug log check How to collect debug information? document.
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
Hi,
Please find attached Log,

We have set the option as recommended "Use file for configuration" but the system is still not changing the values.
In the preview, it shows that it is going to set the values but it fails.

Regards
Stan
Attachments (3)
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hi,

Thanks for your help. We have worked it all out.


Regards
Stan.
  1. more than a month ago
  2. RO CSVI
  3. # 5
  • Page :
  • 1


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