Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

export/import database problem


peteravu

Recommended Posts

Why when I export products to CSV for Ms Excel data, do the changes I want in excel save as CSV semicolonseparated and reimport it, all the prices are with out decimals and the date are 0000-00-00 00:00:00

I found our that it export the price with coma 14,95 but need to be with dot on import 14.95 than it work fine but I don?t know why I have to change , to . every time.

And the date I can?t get back in at all only 0000-00-00 00:00:00 any idea make that?

Link to comment
Share on other sites

you need to check your settings in excel for the particular cells, you probably have the price set up as numbers, when it should be set up as a text field

Link to comment
Share on other sites

Link to comment
Share on other sites

  • 3 weeks later...

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...