You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
Hi all,
I need to submit my shopping cart data on Froogle. I'm certain hundreds of CCP users want this as well.
I got approved, and they gave me instructions to create a data-feed to send them.
It's basically a tab delimited text file, using the following fields:
product_url, name, description, price, image_url, category Sample: http://www.example.com/asp/sp.asp?productid=1006, Widget name, Widget description, 10.99, http:// www.example.com/images/1006.jpg, Home & Garden Category > Kitchen > Accessories
Can anyone create a hack that will allow these fields to be exported from CCP to a .csv file? (one thing - I know it's going to have to grab the base URL and add it to the product URL and image URL names, etc. as this is not stored with the URL data.)
Nick? I'd be happy to fork over a few dineros for this one.
Thanks to all,
Lisa
Offline
While your waiting for someone to write a hack.
This might help. If you export your data as a csv file and import into Excel you can then create a new field and paste this formula into it. I inserted a field at "A" in my example.
=CONCATENATE("http://www.example.com/asp/sp.asp?productid=",B2,",",C2,",",AC2,",",F2,",","http://www.example.com/images/",T2,",","Home & Garden Category > Kitchen > Accssories")
Change fields to match your structure then paste into all your rows.
Save your file as a csv and reopen it prior to deleting all the fields except your formula field. If you're comfortable with Paste Special you can highlite your fuction column and just paste special over its self. Otherwise since its a formula field the new data will dissappear when you delete the linking fields.
Save as your new csv file and then upload to froogle.
Offline
Okay, this is just a bit over my head...
I had already tried exporting my product.csv file and editing it in Excel, it was great for the product, description, price, and even the image file names (complete URL path easily added to those, because it's the same for all) but then entering in the individual product URLS and categories was too time consuming.
Can you give me greater detail on the Excel formula? Where exactly it goes, how it works? I know most of my way around in Excel, so if I can just understand how to implement it, I'd definitely use it.
Thanks,
Lisa
Offline
Open in Excel product.csv
Click on column "A" and insert a new column
Row 1 should contain you Column Names.
Copy the following into cell A2
Cell Column Column Name
B2 product_id
C2 product_name
AC2 product_desclong
F2 product_regprice
T2 product_imglg
Change the above Cell Columns if not the same fields you want.
The Function =CONCATENATE() will combine all the cell information and text into one cell.
Click on Column "A" and Copy column
while still on highlited Column "A" Click edit and Paste Special. Choose Values
The Paste Special will now change the formula information in text (values). You can now delete all the other columns or simply copy the column "A" into a new spread sheet and save as froogle.csv or whatever else you want to call it.
The above will then get you a record like:
I was assuming that your category because of the ">" was text. If it appears this way in your category field then replace this text in the formula with AZ2 for .
Hope I explained it better this time.
Offline
Thanks, Nick!
It works absolutely beautifully! Saved me about 40 hours and one bad migraine!
Thanks again,
Lisa
Offline
Hi,
I tried the suggestion above but I'm totally lost... Nick did you ever finish this mod and if so can I purchase it. I am using tiki with some mods from the forum.
I am close to completing the froogle registration and am looking forward to getting this implemented.
Thanks
Offline
looking everywhere cant find where you export products to csv
Offline
Hi,
I tried this export and it works rather nicely. The only problem I had was when went to get it approved by Google. They wrote me back abd said that they would not honor zero pricing. I though ... Huh?
Anyway, I found out that many of my products were option based. When the export grabs then it treats them as zero prices. Is there a fix we can do for this? Meanwhile, I can just open it in Excel and sort out the zero prices.
Thanks,
Tom
Offline
There's no way to pull in the options because of the format of the Google import file, so the best way to do this is to elimintate them from the export. To do this, open up the file ./cgi-bin/library/modules/adm_froogle.pl for editing and look for:
$export_file1 .= "$field_product_url\t$field_name\t$field_description\t$field_price\t$field_image_url\t$field_category$eol_string";
And change to:
if ($field_price > "0") { $export_file1 .= "$field_product_url\t$field_name\t$field_description\t$field_price\t$field_image_url\t$field_category$eol_string"; } ######### End of if statement.
Offline