Pricing, Shipping Weight, and Flatfiles ...

[kryme]

I posted the following on forums.oscommerce.com, and received no replies. I am hoping someone here is more willing to help me.

I get a flatfile of all of the products one of the companies we deal with quarterly so that I can import it into osCommerce. I have a few configuration issues that, if solved, will save me from editting thousands of lines of data each quarter.

First, the prices of all the products are in USD, but there is no decimal point, so that $17.00 is listed for the item as 1700. Is there a way for osCommerce to look at 1700 and know it's $17.00?

Also, the shipping weights of the items is missing a decimal point as well. Is the same setting for the price available for the shipping weights?

Some of the category names in my flatfile are too long. When they're longer than allowed, they're cut and duplicated. How do I go about changing the maximum length of the category name?

I use EasyPopulate to import the flatfile. I seem to remember there being a file which listed all of the column headers available for osCommerce, but I cannot find it. Is there a file or a URL that lists all of these?

Thanks in advance

[peteyg]

What you can do inside excel is highlight all you columns then click on data and then click sort. Choose the column with your prices and choose ascending or descending and it will sort out all your item for you from the most to least expensive. So now by groups you can format the column take of the extra zeros for easy populate. Then do the same instructions for your weight (make sure you highlight all columns or your weight wont match items) and place the decimal where you need it.

[unixace]

To answer your question on the categories you need to increase the category width in your database table to allow longer descriptions. Easy populate truncates descriptions to the database field length.

In categories_description you need to use phpMyAdmin to change the length of categories_name to be as long as your longest description. The default is just not long enough for your data.

I do a lot of Excel data conversions. I would add an empty column next to your price and weight columns. Then enter a formula to take the populated column and divide by 100. Copy the new column and use paste special with 'values' selected to replace the original column. Delete the column you inserted and format the price and weight columns as numbers with two decimal places. Save out your csv file and import.

Hope that this helps.