Exporting Actinic csv file to Spreadsheet

[FreddieFly]

Hi guys,

It's as you see it above!! How to export stock codes,prices and descriptions from Actinic onto a spreadsheet ?
I keep getting the whole site. Spacers,tab buttons and much much more....
Can anyone help me please ?

[leehack]

Export the lot and delete/sort/filter what you don't want. It's an all or nothing export.

[FreddieFly]

That simple... I'll give it a bash. Cheers Lee.

[FreddieFly]

Jeeezeee...
I got attributes, permitations, choice and sooooo much more to delete....i'm thinking it would be easier to start from scratch.... Create a new spread sheet, input all products, Input codes and prices..... What a mammouth task !!!
Musty be an easier way....?

[chris ashdown]

Hi

Jan at moleend has a small software package calle Profit and Pricing tool which will do what you want, you can also update some or all prices by a % or amount and other things as well, Bit pricey as only vaid for a year (used to be a version) but very handy

[Jan]

The profit, pricing and stock tool mentioned above is here :

http://www.mole-end.biz/acatalog/Pro...ng_Tool_b.html

but you could also use our Actinic flat file export mash to produce a flat file that you can edit and then import into actinic using file / import to change prices.
That is here and is a bit cheaper :

http://www.mole-end.biz/acatalog/actinic_Mash.html

Regards,

[FreddieFly]

Hi Jan,
Thank you for your reply.

You seem to be welll respected on here and on tinternet.
I've tried the pricing tool and the masher.... I get more joy out of the pricing tool but it's not got all the info. I need product codes, prices and description eported on to a spread sheet. Csv stylee....
I really struggle with the masher... is there a secret ?

[Jan]

Both products can produce a file with product code, description and price. But only the main product price will be exported - do you have prices on your options?

What is missing from the profit and pricing tool export?

For the mash, run up the program and untick all the boxes on the right hand side export for the one called "Actinic Flat File Import", then click on options, enter the name of the file you want to create in the box called Output Filename and select the information you want to include in the export file by ticking the sections below. Then close the options, click on the Mash now button on the main screen and you should then have your file.

Regards,

[FreddieFly]

Hi Jan,

Thank you for talking to me earlier. I think i have it !
Seems to be working with a few adjustments.

Once again thank you for all of your help.