Author Topic: Adding Excel File Upload option to product_csv module  (Read 320623 times)

keesjanisse

  • Beginner
  • *
  • Posts: 2
Re: Adding Excel File Upload option to product_csv module
« Reply #195 on: January 22, 2008, 00:55:30 am »
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

  • Beginner
  • *
  • Posts: 2
Re: Adding Excel File Upload option to product_csv module
« Reply #196 on: January 22, 2008, 01:38:15 am »
SOLVED

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



MiHu

  • Beginner
  • *
  • Posts: 43
Re: Adding Excel File Upload option to product_csv module
« Reply #197 on: January 22, 2008, 02:54:03 am »
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. :D

[attachment cleanup by admin]

jean.roux

  • Beginner
  • *
  • Posts: 4
Re: Adding Excel File Upload option to product_csv module
« Reply #198 on: January 22, 2008, 17:50:54 pm »
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

  • Beginner
  • *
  • Posts: 1
EN ESPAÑOL - Adding Excel File Upload option to product_csv module
« Reply #199 on: January 25, 2008, 15:32:51 pm »
 ;D

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

  • Beginner
  • *
  • Posts: 5
Multiple prices upload - Is is possible?
« Reply #200 on: January 26, 2008, 03:16:17 am »
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

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #201 on: January 26, 2008, 05:07:42 am »
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.


 
 
Joomla/VM Upgrade Services. Problems with your migration? We can help.
Custom extensions to VM. Performance Tuning. Template modifications and advices.
Pay service to make VM work according to your needs. Your Joomla/VM solutions are just a PM away.

conken

  • Beginner
  • *
  • Posts: 5
Re: Adding Excel File Upload option to product_csv module
« Reply #202 on: January 26, 2008, 05:41:46 am »
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

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #203 on: January 26, 2008, 06:36:09 am »
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.
Joomla/VM Upgrade Services. Problems with your migration? We can help.
Custom extensions to VM. Performance Tuning. Template modifications and advices.
Pay service to make VM work according to your needs. Your Joomla/VM solutions are just a PM away.

conken

  • Beginner
  • *
  • Posts: 5
Re: Adding Excel File Upload option to product_csv module
« Reply #204 on: January 26, 2008, 07:14:06 am »
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

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #205 on: January 26, 2008, 07:25:20 am »
The product_price must match the original price. You can't use 0.
Joomla/VM Upgrade Services. Problems with your migration? We can help.
Custom extensions to VM. Performance Tuning. Template modifications and advices.
Pay service to make VM work according to your needs. Your Joomla/VM solutions are just a PM away.

Maccadon

  • Beginner
  • *
  • Posts: 18
Re: Adding Excel File Upload option to product_csv module
« Reply #206 on: January 30, 2008, 23:03:58 pm »
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

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #207 on: January 31, 2008, 00:11:54 am »
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.
Joomla/VM Upgrade Services. Problems with your migration? We can help.
Custom extensions to VM. Performance Tuning. Template modifications and advices.
Pay service to make VM work according to your needs. Your Joomla/VM solutions are just a PM away.

Maccadon

  • Beginner
  • *
  • Posts: 18
Re: Adding Excel File Upload option to product_csv module
« Reply #208 on: January 31, 2008, 07:49:30 am »
You were right. I turned off an on the SEF404 and everything works.Thank you for everything

thesweetheaven

  • Beginner
  • *
  • Posts: 6
Re: Adding Excel File Upload option to product_csv module
« Reply #209 on: February 01, 2008, 08:56:19 am »
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.