Creating a spreadsheet I can use as a basis to upload to amazon

-- HikaShop version -- : 2.6.3
-- Joomla version -- : 2.5.28

Hi - I have just created around 200 new products on my own website - farangshop.co.uk - I now need to add them to my seller account on amazon too.

Just choosing the export function does not really help a non-technical use like myself.

I believe it is possible to create a mass action to export the product fields I want into a spreadsheet, and then I don't mind cutting and pasting the appropriate columns into an amazon upload template so I can at least speed up the process considerably. Can you explain step by step how I do this, as I don't really follow it just looking at the mass actions page.

I want to export a spreadsheet where I could get all the main product information fields:
Name
Product Code
Quantity
Price
Description
Keywords
Weight
The three volume fields

In an ideal world, the same for the variants where they exist.

Any assistance appreciated.
Regards,
John

Thanks for the response, but it does not seem to work for me.
I would have expected it to make a spreadsheet with all the fields I had selected along the top and the corresponding info for the products underneath.
Instead I get the A1 excel box filled with:
product_code;"product_description";"product_dimension_unit";"product_height";"product_id";"product_keywords";"product_length";"product_name";"product_quantity";"product_weight";"product_weight_unit";"product_width";"price_currency_id";"price_value";"images_name";"images_path";"related"

That's all in the one box, then I can't make any sense of the info produced.

That's the CSV option. If I choose the .XLS option I can only generate a file that is damaged and can't be opened.
Any ideas please?

Do I need to select any filters?

After much trial and error, I think the problem may be my description field.

I have a lot of products - 1,874.

I just get errors when I export any fields including the product description, but the other info I can export to a spreadsheet.

Any suggestions on this. I can select "Display" instead of exporting the CSV and all works okay, but how can I get that info into a spreadsheet?

Thanks, but it is the products I want to export and not the orders. There is no date filter for products.

I've isolated the problem just to the product description field.

I can export an XLS spreadsheet of any of the other data, but it just won't work if I include the product description, or even if I just export the product descriptions on their own. it only produces an unreadable corrupt file - presumably the problem is connected with the volume of data - 1,874 products with detailed descriptions for each.

If I just process the information for display only, there is no problem. It displays the descriptions on screen, but I can't find any way of cutting and pasting (Excel comes back with the message it cannot paste the data), or downloading that data so i can't use the information.

Many thanks. I would like to try it with date filter in that way. Apologies, but can you spell out clearly for me an example of a 'unix timestamp of the date' so I understand the format required. Sorry, but I'm not a developer and don't understand what this means.