Froogle Feed Question

[otiz]

I have uploaded my actinic export feed to Froogle but get a message from Google to say

VAT included GBP prices only: We noticed the prices on your product pages
include VAT, however the prices in your feed don't. Please only include
VAT included GBP prices in your data feed. At this time we're only able
to accept sites and products that display VAT included prices in GBP and
include those prices in their data feed

Question is how do i include the vat prices when i use the export froogle feed feature?

THANKS

pAUL

[pinbrook]

multipy your price column by VAT

[otiz]

hi Jo
Sorry have no clue what you mean?

Paul

[otiz]

Hi Jo
All i do is use the export froogle feed from actinic, then upload with my ftp
dont know how to x the vat coloum or where?

Thanks
Paul

[cdicken]

1) Open your Froogle export in Excel.

2) Put your cursor in cell I4 (first empty column)

3) Type '=' into the cell.

4) With the mouse, click in cell D4 (the first entry in the 'price' column)

5) In cell I4 type '*1.175'

6) The content of the cell should now read '=D4*1.175'

7) Press Enter. The inc VAT price will appear in cell I4.

8) Press 'Ctrl + C' to copy the cell to the clipboard.

9) Highlight all the other cells below the one you have copied.

10) Press 'Ctrl+V'. This will copy the fomula to all the for all the rows in the export.

11) Now highlight all your inc VAT prices. Press 'Ctrl + C'

12) Place your cursor in column 'D4' and go to 'Edit | Paste Special'. Click 'Values' and then click 'OK'. This will paste your new numbers into the 'price' column.

13) You can now delete the contents of column I.

14) Now highlight all the values in the 'price' column and go to 'Format | Cells'.

15) Change the 'Type' to 'Number' and ensure 'Decimal Places is '2'. CLick OK.

16) Save the file, close Excel and then re-open the file in Notepad. Check it still looks OK.

[omulcock]

Or use Froogle Mash from Mole End. www.actinicplugins.co.uk - free and easy to use. Does the job in half the time.