Resolved Importer Not Working

Hello,
The debug log attached is incomplete. Please attach the complete debug log file to check. From what i see in your debug log is that you are using custom table import for importing VirtueMart products. You should be using VirtueMart product import operation to import products into VirtueMart tables.

This is a custom component by the way. I have attached the debug log.

Can you explain more on what you are saying as custom component?

its not virtuemart... it was many moons ago when we first started building the system. However we dropped VM in the last update and rebuilt everything.

Custom Component as in a Joomla component we built ourselves. It's called ProMart.
com_csvi.log.325788.txt.zip

Hello,
Ok i see that you are using CSVI custom table import operation to import products into your custom component. Please load the patch file attached in this post so you get the records inserted. But there is a hitch in this import, you have set product_sku as import based on field in your template settings and on options tab which is a string field and CSVI looks for integer primary key field with auto increment. I would suggest you change your import based on field to auto increment field in your table which i guess is virtuemart_product_id and then run the import.

I need to use the SKU

Where do I get the patch file?

Hello Dave,

The patch file is in the link Tharuna provided, to be specific this post.

Let's forget about the primary key needing to be an integer value for now. I assume the product SKU is not the primary key of your table right?

ah thanks got it now!

SKU is a key but not the primary key. I have an id setup on there. It's just that I have multiple suppliers and using an ID to update is not that easy as they all have their own SKUs

I set a prefix for each supplier and use their SKU after the prefix generally.

Hello,
We are working on the code to fix the custom table import so now when the record does not exist with the value of import based on field it gets inserted else the record gets updated. Will post the patch when it is ready.

Hello,
The patch for custom table import is ready for testing. Please load the attached patch file from CSVI maintenance menu and then run your custom table import with import based on as product_sku. Check if the new rows are inserted when the records don't exists.

patch_csvi_2017_10_24.zip

worked perfectly. thanks!

Hello,
Glad to know that the patch worked. Would appreciate if you can give us a review on Joomla Extension Directory.

ok I'm trying to set this up on another site....

Identical templates both with the patch loaded.

One site is working and overwriting the data based on product_sku and the other is creating new products each time.

Any ideas?

just checked again and it appears one of the sites is not importing the product_sku field

Hello,
Can you post the import debug log and sample import file to check?

Here are the files

Hello,
Your debug log shows that the products are updated. I don't see any new products created or any issue with your import from your debug log. Can you explain more on what you mean by "it appears one of the sites is not importing the product_sku field"?

Ok I have added 5 new products to the bottom of that csv. all with SKUs

However when they import it does not import the SKU

Hello,
Your latest import debug log says it all. You are still running the old code and patch for custom table import changes is not applied to the site you are now running the import. Apply the patch file and make sure that all the files are copied successfully and then run th import again.

odd I've defo uploaded it...

Hello,
Apply the patch again and make sure that all the files are copied.