15% price decrease on stock.

[SPS]

Hello,

I am trying to bulk change my pricing on 1000 products, was going to use mole end but they have withdrawn their software.

I have tried to export the catalog to excel but the product pricing decimal point is missing e.g. 14.99 shows in the cell as 1499

Does any body know the best way to sort this out, it also shows all deleted products in the file aswell.

Any points on uploading the file aswell would be appreciated.

I have backed up the site.

Thanks.

[NormanRouxel]

SellerDeck uses pence internally for the prices. Just do your calculation on the 1499 type entries and round the result (up or down - your choice) to make them integer.

See Excel's help for how to do the arithmetic.

[chris ashdown]

Make a file like this in excell and then save as .csv format

Use import under file and should then update prices

Product Reference Cost Price Price
15001 1302 1682
15002 1596 1814
16001 4947 4125
16002 2995 3493
16003 2406 2808
2035 995 1349

[SPS]

thanks you very much gentlemen it is much appreciate it has worked, was just worried I would over price without the decimal point.