Resolved Removing line breaks

Hello,

But it won't remove the line breaks causing the import not to work

Having linebreaks shouldn't be an issue for the import.

The import log didn't attach, can you attach it again for review? What is the issue you have with the import? "Not working" doesn't really tell me much

Import log attached.

The export contains just product_sku codes. Then I import this file back in and with product_stock in the field set to zero as default

It's supposed to turn off all stock. I have another import file which has the true stock value. (The reasoning behind this is because the wholesaler sometimes takes products off the database without allowing the inventory to sync with my website).

com_csvi.log.2.txt

Hello,
You debug log shows that the import is having issue at line 47 and till then products are updated, can you post a screenshot on the error you see while running the import? Also attach the import file to check.

Hi Tharuna,

No errors show when running the import or when it's finished...

I can't upload the import as it's too big to be attached.
unpublished.csv

Hello,
First issue about your import file is that there is empty line after each row. CSVI would throw error "Missing product_sku field" for these empty lines. You should remove these empty lines from your import file. If you are having problem in importing large files, check Manage Timeout document.

I've added a rule to remove empty lines but it won't remove them, hence my support email.

Hello,
In that case, create a Skip rule for import, in the rule settings select method to match to be Regular text, Values to match to be empty. Apply this rule on product_sku field. Run the import and see if empty lines are skipped.

Yep that fixed it - brilliant thanks! :woohoo:

Bit weird that it wouldn't work on the export file as would have been quicker to find out it worked, however not complaining.

Anyone reading this - be sure to turn on the extra plugin for the rule to work!

Cheers T.

Hello Jamie,

Yep that fixed it - brilliant thanks! :woohoo:

Glad to know that it worked. Please leave us a review on Joomla Extension Directory.

Bit weird that it wouldn't work on the export file as would have been quicker to find out it worked, however not complaining.

Do you have empty records in #__virtuemart_products table? That should be a reason you are seeing empty lines in your export. Can you post a screenshot on what you have in #__virtuemart_products and #__virtuemart_product_XX_XX tables? (XX_XX is the language you are using in VirtueMart )

Hi T,

I've attached both files and removed half the products as too big to upload.

I do see thousands of products with Language Missing id #### as Product Name in VM. I imagine this is because I'm not deleting products that no longer exist.

Archive.zip

Hello Jamie,

I do see thousands of products with Language Missing id #### as Product Name in VM. I imagine this is because I'm not deleting products that no longer exist.

You would see Language missing... text when a product does not have a product name. Looking at your VirtueMart product tables there are no empty records. I am still not sure why you see empty lines in your export. Can you send me the MySQL dump of all of your VirtueMart tables to check?

T,

I've uploaded the database 18.5Mb - http://www.kimsons.co.uk/kmsnsE4SsM.sql

Thanks

Hello Jamie,
Thank you for sending me the database tables. With your table data and export template, i don't see any empty lines in the export. What if you open your export CSV file with some other program like OpenOffice? Do you still see empty lines? As much as i can see there is no problem with export.

When opened in Excel there's an empty line between records.

The Language Missing id makes for thousands of products which have no price. I'm wondering if this is due to the stock import and not removing products from VM .

Hello,

The Language Missing id makes for thousands of products which have no price. I'm wondering if this is due to the stock import and not removing products from VM .

Language missing id will be shown when a product has no name set to it. If you want to remove products from VirtueMart using CSVI you need to use product_sku field with SKUs of the products to be deleted and product_delete field set to Y in your import.

Thanks, I'll give that a try when I've got some spare time