Moving OSComm Catalog to PS?

[roback]

Is there a way to simply (tongue in cheek) move my OSComm Database - customers and catolog specifically - to PS?

Either through the admin interface or through MySQL?

new to PS but like it thus far.

[TropischBruin]

If you cannt spell osCommerce right your probably not really into osCommerce.
I run a shop in osCommerce and for the moment I cannot see any point in switchin over to PrestaShop due to the fact that it is to soon.
PrestaShop is nice but there are to many things missing or not completly functioning to even replace a full modified osCommerce shop.

There is not an easy way to export form osC and import into PS.

[radders]

Categories and manufacturers are easy to copy, products a bit tricky mostly because of timeouts, images and special characters. Customers I have yet to try but the main problem is that the password system is different.

I am a lot closer to making the switch than I was a year ago and progress has been quite rapid in the last few months.

Mainly waiting for:

customer import from oscommerce
sales report including details of products sold so we can pick the orders
invoices that can accomodate more than one address format so we can ship overseas
order editor for those little adjustments that support good customer service.

[roback]

Thans Radders.... maybe there is a way I can take our master list (excel, not OSC) and tweak it a bit to match, as best as possible, with the PS upload format?

Our shop is relatively new so we are not critical about copying customers or past orders. OSC is just becoming too much of a hassle to implement new features and PS has nearly all of what we are looking for.

Thanks again!

[TropischBruin]

Customers I have yet to try but the main problem is that the password system is different.

Why not send an Newsletter stating that the shop has been changed and that the customer has to request a new password the first-time they visit?

[Dio]

Thanks Radders Really good tool

[radders]

I am sure it wouldn't be a problem to import the everything apart from orders from excel. You may need to save things using UTF-8 setting. A newsletter offering a discount for a limited period should persuade existing customers to make the effort (for those customers who have opted-in to receive a newsletter).

[roback]

I am just playing with it right now... a little bit different, but relatively easy... just a matter of combining some columns and adjusting a little bit of data... but should be easier than I thought.... another happy experience with PS!

[roback]

Okay, a bit of trouble with the upload.Here is a sample line of my csv file:

2940;COAST ARCTIC SURF SOAP ;Short Description;img/products/2940.jpg;5.69;Health & Beauty,Soap & Body Wash,Soap - Bars;Coast;1;10000;EOREOR

So I have:
Id;Name;Short Desc; Img URL;Price inc tax;categories(top, second, third), Brand (Manufacturer),Status,Quantity, ingore last row.

Now it appears to go well, with no errors but when I return to the catalog area, it has hadded the categories, but it has not retained the structure - they all appear to be top level categories. It shows all categories as active with appropriate quantities available, but they do not display in the categories list on the front end.

then it imports the Brands (I have modified the manufacturers to be Brand) correctly and under the brands it has the correct products.

Then the products themselves are not available. I cannot see them under any category. I cannot see them under the home category. I cannot see them anywhere, except that the quantities displayed in the categories indicates they are there and the list under each of the respective Brands (but you cannot access the product editor from there.)

So I cannot figure out what is wrong. I have done this about 6 times. the first few I adjusted things to make it more complete, but the last 3 were simply trials to ensure I was not missing any settings on the upload or in the formating of the csv.

Any help?

[radders]

Yes, category is a number sequence not a series of names.

[roback]

a number sequence?

In the column assignment it shows: Categories (x,y,z).

I understand that to be alpha not numeric.

How would I put the categories in otherwise? Or how should/will I achieve putting this in?

[phantomeye]

Hi ,
Ive actually successfully imported about 500 products using the import tool. The only part i have not been able to to is import images, which if someone can help me with, i would really appreciate it.


ID, Active, Name, Categories, Price, Short description, Description, Text when in-stock
199, 1, Phantom, 3, 99, Phantom, Prestaexplorer, Item in stock


Notes
1) ID: you want to use a new number, to see what number to use, just create a dummy product and see what product ID is assigned to it. If you use a previously assigned product number, it will be overwritten with the new data

2) [bNAME][/b]: this is the only mandatory field

3) Categories: just like in ID above, you need to check what is the assigned category number you want to place the product in. To look up your category ID, click on the catalog tab and see the list and assigned ID

Important
1) While importing, ensure you first upload the file
2) Then select the type of import from the drop down; in the above case it is Products.
3) Then select the uploaded file from the drop down list
4) Change the field separator from ; to ,
5) Click next
6) Since i use column headers in my CSV file, i skip 1 line, so enter 1 in the "lines to skip" field
7) Align the CSV columns with the fields to import to
8) Presto click import and you are done

Ive tried importing images, using the image url, but im showing the 404 error image. The format is was using for the image url was :

themes/prestashop/images/newimage.jpg
http://mydomain/themes/prestashop/images/newimage.jpg

both gave me the same error.

Hope the above helps you and im looking forward to someone helping me with importing images as i have about 5000 images and products to import. !!!!

Cheers

[radders]

In my case the original images were all to be copied from the images directory of my site so I simply used urls of the format below:

http://www.mydomain.com/images/xxxx.jpg

[phantomeye]

So ive tried the following permutations and combinations to try and upload the images using the import tool. Just cant figure out what im doing wrong. Each time it says upload succesful, but when i goto the product, i see the 404 error image.

The steps i follow is first upload the image using my FTP client, then upload the CSV file and then import the file. Ive used the format as follows:

ID, Name, Image url

1) 524, This is a test, /themes/prestashop/images/newimage.jpg
2) 524, This is a test, http://mydomain.com/themes/prestashop/images/newimage.jpg

3) 524, This is a test, /upload/newimage.jpg
4) 524, This is a test, http://mydomain.com/upload/newimage.jpg

5) 524, This is a test, /img/temp/newimage.jpg
6) 524, This is a test, http://mydomain.com/img/temp/newimage.jpg

Ive checked the CMOD permissions and they are all set to 777. Really goin nuts on this issue >

[roback]

Okay I still cannot get my products to appear in the Categories (or sub categories) "Products in this Category" section. I have my categories loaded correctly and from the fact that there are quantities in the "In Stock Products" Column of the Categories List and there are products attached to the specific manufacturers, but none of them are showing up in the Products in Category section.

I am baffled. I am not sure what I am doing that is causing this to happen. Any suggestions?

Can someone send me a file they have used that has worked so I can test and analyze as a sample?

Thanks

[phantomeye]

ID, Active (0/1), Name, Categories, Price, Short description
199, 1, FREDDY, 42, 24.5, FREDDY KRUEGER
200, 1, GLO ALI, 42, 5.16, GLO ALIEN
201, 1, HOCKEY, 42, 1.75, HOCKEY MASK
202, 1, HOCKEY, 42, 1.75, HOCKEY MASK

Note in the above sample file:
199 - 202 - is Product ID
1 - sets the product as active (this will display the product in the store front)
Freddy - this is the product name (mandatory field)
42 - this is my category id, where i want these products to go
24.5 - product price

It also had descriptions but that was too long to include here. We may be able to help you better, if you show us you're file. As i mentioned before, i was able to import the products, but cannot import the images. Im on a godaddy server(SUCKS) and am using Prestashop 1.2.2

[phantomeye]

Insert Evil laugh
Bwahahahahhaha.... i figured it out.

So for some reason if i used the upload tool for my csv file, it would not upload the images. However if i directly FTP'ed into the Import folder and added the csv file, the images uploaded perfectly. Dont know why, but hey it worked !! Now i shall start uploading the 5000 images !!!

Yippeee !!

[TropischBruin]

Insert Evil laugh
Bwahahahahhaha.... i figured it out.

So for some reason if i used the upload tool for my csv file, it would not upload the images. However if i directly FTP'ed into the Import folder and added the csv file, the images uploaded perfectly. Dont know why, but hey it worked !! Now i shall start uploading the 5000 images !!!

Yippeee !!

That is because the csv-import cannot upload files/images but only data like text and/or urls.

[roback]

Okay this is what my file looks like:

2940;COAST ARCTIC SURF SOAP              ;ShortDescription;http://localhost/WWW/PRESTA1/img/products/2940.jpg;5.69;96;Coast;1;10000;EOREOR
2941;COAST ORIGINAL BLUE                 ;Short Description;http://localhost/WWW/PRESTA1/img/products/2941.jpg;5.69;96;Coast;1;10000;EOREOR
2942;COAST PACIFIC FORCE HAIR & 98  ;Short Description;http://localhost/WWW/PRESTA1/img/products/2942.jpg;10.99;98;Coast;1;10000;EOREOR

2940 - Product ID (I have tried leaving this blank to allow it to assign it on its own - results are no different with or without.
COAST ARCTIC... - product Name
Short Desc... - Filler for Short Desc. field
URL.jpg... that is the full path to my localhost server where the product images are located. (Haven't gotten to a point where I know if this works or not)
5.69 - Price inc Tax
96 - Category (this appears to work as the quantity of products in (sub)categories corresponds with the imported file quantity.)
Coast - Manufacturer
1 - Active/Inactive - I believe 1 is the active variable.
10000 - Quantity (Just a dummy figure as quantity is not important to us, but imported it as thought it would effect the availability/visibility of the products
EOREOR - Ingored field. OSC Easy Populate inserts.

So Let me paste what I see in the Catalog section:

90 Cleaning Products ... 180000 << this last number is the "In Stock Products" column.
88 Health & Beauty ... 950000

No products in top categories, but drill down to sub categories and there still is no products, but the "In Stock Products" shows a quantity.

When I go to the Manufacturers tab, it shows the manufacturers (Imported with upload):
27 Coast -- 9
28 Combat -- 15
29 Dial -- 84
30 Dry Idea -- 4
31 Purex -- 4
** Note the last number in each row is the "Products" Column.

Clicking on the manufacturer and it brings up the list of all the attached products:
PUREX 2X AFTER THE RAIN LIQUID DETERGENT

--------------------------------------------------------------------------------
PUREX 2X BABY LIQUID DETERGENT

--------------------------------------------------------------------------------
PUREX 2X FREE & CLEAR LIQUID DETERGENT

--------------------------------------------------------------------------------
PUREX 2X FRESH SCENT RENUZIT LIQUID DETERGENT

But these and none of the other products do show up in the Catalog area nor do they show up on the front end.

any ideas as to why this is not working?

?

[phantomeye]

i think this has something to do with the field separator you are using. If this is a CSV file, then you need to change the field separator from ; to , (semicolon to comma)
In anycase attached is a CSV file, all you need to do is fill in the required columns and then upload the file. Make sure you change the default field separator from ; to , in the import BO window.

By using the same product IDs as above, you will be replacing the current products with the new information.
For the image URL, i uploaded them via FTP to a new folder in mydomain.com\upload\newimagefolder and then placed each images complete url in the csv file.

Lets hope this works.

oops almost forgot, upload the csv file directly using the ftp tool rather than the upload tool.

Sample.csv

[roback]

thanks, I believe I found a minor fix to the categories no displaying. I went into the category editor and the friendly URL field was blank. I filled it and the categories appeared on the FO category list, with all sub categories. and there were the products in there as well!! Yippie!

(Oops forgot to mention... the products were still NOT showing up in the admin under the categories... sigh)

Now the images were not there, as I am assuming the paths were uploaded incorrectly.

Progress...

I will try this file shortly and let you know.

Thanks!

[roback]

Does the semicolon/comma separator really make a difference? They are declared in the upload page settings and i have verified that column separator is a semicolon and value separator is a comma?

Might be a foolish question, but how do you control what is used as a separator in Excel 2007 CSV saving?

also have any of you experienced a stalling on the CSV import? I have a file of approximately 70 products I am trying to import and it seems to be stalled (going on 35 mins right now). Should I abandon this and attempt again?

Thanks

[phantomeye]

Yes the changing of the field separator is important. If you are using a CSV (comma separated value) file, then the field separator in the BO Import tool needs to be changed from the default value to a comma.

You do not need to change anything in Excel, when saving as a CSV, only in the BO import section (see attached image)

The hang maybe because of the images (too many and the server may timeout).

[radders]

You can get a server timeout but with only 70 products I wouldn't have expected it unless there are many images for each product or perhaps the images are excessively large. I always use '|' as the separator in my files because comma and semicolon crop up in the text so can confuse the system.

[roback]

confused as to why the images would impact anything? You are not actually importing images you are merely importing a desired path to the images?

Unless I am mistaken and that path is actually used to pull the images from the said URL and resave them in your img directory?

Please clarify?

[radders]

That path is actually used to pull the images from the said URL, resize them and resave them in your img directory.

[roback]

ah... that could indeed take a long time then...

Is there any way to simply provide the image's URL?

i will be trying with 10 products when I wake up on a live server... almost 3am.. time for me to get some shut eye..

thanks for your help and input!

[radders]

Not sure, though what I can recommend is to use the free Prish Image Resizer (Google it!) on your images before uploading them and running the import.