Importing product line

[jskaiser]

I am trying to import a list of product

item
short description
long description

and price


the prices I have example 12.95
when importing error tells me that I can only import prices that are 1295 no decimal. any ideas

[Jan]

Actinic stores it's prices in pennies so you need to multiple your prices by 100 before importing them.

Regards,

[jskaiser]

Ouch

I have over 37822 products with Prices already in my excel and csv format/ Now I will need to convert them.

[jskaiser]

This is screwed up

I thought it would be easy converting bu it is not for example
when I change 12.95 to the next highest I get 13 no 1300
this sucks

[NormanRouxel]

when I change 12.95 to the next highest I get 13 no 1300

Not sure what "when I change" means.

Here's what I'd do.

Create a new column in Excel. Set its top cell to have a formula of 100 times your decimal price top cell. Duplicate that formula for the entire column. Check that the values look sensible. Use that column for the import price field.

Excel has plenty of built-in help if you don't know how to do these basic things.

Norman

[jskaiser]

take a look

Hope this helps

All I want to do is chang all 37800 products prices with the 2 zero at the end example

37.00 would be 3700

[NormanRouxel]

See my answer above.

Norman