Adding Excel File Upload option to product_csv module

[keesjanisse]

Thanks for making this available. This is a real time saver !!! As I'm currently converting a "non-virtuemart product DB" (more than 10.000 products) into VM, this will do the trick !!
One question: can't get the fields product_full_image and product_thumb_image to work, where i copied the specific jpg images to the concerning folders ...components/com_virtuemart/shop_image/product/ and components/com_virtuemart/shop_image/product/resized

Any suggestions on this ?

many thanks !
rgrds Kees

[keesjanisse]

SOLVED

problem above : didn't apply the field product_price yet
doing that, ...it works !! 

[MiHu]

MiHu,
Can you provide a sample xls for testing?

I just downloaded the hack file again and remove the image and image thumb field.
I removed all the product and then import from this file.
All products appear as normal product but not child-parent product.

thanks for the response.

[attachment cleanup by admin]

[jean.roux]

Dear Joseph Khan,

You were right, the fix in reply #181 did solve the problem. The offending characters were ' and ". This solved it.

Thanks a lot!

[MUSICOELECTRO]

 

Aquì les dejo un aporte.

Todo el archivo de lenguaje del VIRTUEMART incluyendo la traducciòn de este excelente modulo hecho por Joseph.

Solo reemplacen el archivo:
/administrator/components/com_virtuemart/languajes/english.php

Exitos!



Here is the spanish version of all VIRTUEMART component, including the translation of this excelent module maded by Joseph

Only replace the file:
/administrator/components/com_virtuemart/languajes/english.php

Regards!


[attachment cleanup by admin]

[conken]

Hi,

just a simple yes or no would be great, I have spent a couple of days trying to complete a 'multiple prices upload' for 5 products with 5 'price quantity' prices. The default and customized xls uploads work a treat but the quantity price uploads, this I am having a problem with. I have followed the documentation for the csv upload with no success and can find nothing on this forum or the web about the xls version.

Is this in fact possible with this hack?

Cheers

[Joseph Kwan]

Mihu,
Your sample file doesn't have the product_parent_sku column which is essential to build product-children relationship

MUSICOELECTRO
Thanks for the Spanish translation. I guess you should rename the file to spanish.php. Will include this in our next update.

conken
Basically anything possible with CSV should work in XLS and anything not probably will not also in this hack. To help us diagnose problem, please provide a sample.


 
 

[conken]

Hi Joseph,

thank you for your reply and the opportunity to pick your brains... I have tried to upload using the multiple prices function with all columns included...

http://members.westnet.com.au/conyan/multi_sample01.xls

and with only the columns stipulated in the multiple prices upload procedure document...

http://members.westnet.com.au/conyan/multi_sample02.xls

I have been trying to do this on two computers both with Joomla 1.0.13, Virtuemart 1.0.13a and your hack_Virtuemart_xls_upload.0.6.zip, one PC one Mac and I'm starting to feel like a bit of a plonka for not being able to work it out!

Regards

Con

[Joseph Kwan]

Con,

I'm sorry to report that the Multiple Price upload has a big flaw. It can only add a new price, not update the price. So, unless you can modify the code in function MultiplePricesUpload in the ps_csv class, price upload must be done in 2 steps:
1. delete the price first
2. upload the new price.

By the way, I noted your xls has a column product_delete which has a value 'Y'. This column is not needed although it does not generate any error. If you want to delete a price, the column header should be price_delete.

[conken]

Hi Joseph,

thank you for that clarification and pointing out my error on the product_delete, considering it clearly says in the documentation the column needs to be price_delete (you might have guessed I'm not a programmer).

I amended the simpler worksheet (multi_sample02.xls) from product_delete to price_delete and set the prices to 0 and uploaded using the multiple prices function. In the preview it is showing only the first price_quantity_start and price_quantity_end values from the top line and applying them throughout. (see preview.xls). When I continue with the upload I am told:

Line 1: Price cannot be found Product SKU: C0030
Line 2: Price cannot be found Product SKU: C0030
Line 3: Price cannot be found Product SKU: C0030...etc

Updated   0
Deleted   0
Added   0
Skipped   0
Incorrect   10
Total   10

Revised upload xls
http://members.westnet.com.au/conyan/multi_sample04.xls

Show preview result:
http://members.westnet.com.au/conyan/preview.xls


Con

[Joseph Kwan]

The product_price must match the original price. You can't use 0.

[Maccadon]

I got a problem.
I used this hack before and it worked perfect, but that was only a test.
I now made a complete excell file with all my products.
It uploaded perfect and in the admin section i can see all my products and categories.
But when i get to my site it doesn't show any products.
When i manuelly put a new product in it shows it like it should.

I made sure the option Check Stock is off in configuration.
I also looked at the shoppergroups but nothing seems to help?

I don't know where to look anymore..

[Joseph Kwan]

There can be several possible reasons why the products are not shown. In your case, the categories are imported perfectly. But look like the category_id is incorrect. Not sure whether you have modified the code in shop.browse.php or maybe a problem with the SEF you are using. Can't help without looking at the detail.

[Maccadon]

You were right. I turned off an on the SEF404 and everything works.Thank you for everything

[thesweetheaven]

Hi joseph

already read up the threads few times but cant make the hack working. tried both version 0.52 n 0.6. exactly followed the manual given. tried on and off the sef already still not working. upload sample provided n only edit the category_path to suit my website. got parent n child product.

www.thesweetheaven.com is the website.

fyi, im using Joomla! Stable version is [ 1.0.13 ] , vm 1.0.13a , sh404SEF_Version_1.3 and few others mod n component.

plz help me anyone!

thanx for ur reply.