Jump to content
Sign in to follow this  
mushindo

Automatic Store Feeds Contribution

Recommended Posts

i know this is going to sound very lame but does anyone have the signin/up URLs for MSN,yahoo etc

 

google was easy to find but my serach talents are letting me down this morning <_<

 

TA

 

Si.

 

ok Ive found MSN one at https://adcenter.microsoft.com/ sorry no thats the wrong one i think

Edited by scranmer

Share this post


Link to post
Share on other sites

Just installed this and tried to run Bizrate feed. Site is hosted on a shared server at StartLogic. Am getting these errors:

 

Warning: fopen() [function.fopen]: open_basedir restriction in effect. File(/[path to .txt file in /feeds]) is not within the allowed path(s): (/home/[username]/:/usr/lib/php:/usr/local/lib/php:/tmp:/var/tmp:/home/vdeck/tmp/:/usr/local/bin/mogrify:/usr/local/bin/convert:/usr/sbin/sendmail) in /home/[user name]/public_html/catalog/admin/bizrate.php on line 282

 

Warning: fopen(/ecommerce/os/catalog/feeds/shopzillafeed.txt) [function.fopen]: failed to open stream: Operation not permitted in /home/[user name]/public_html/catalog/admin/bizrate.php on line 282

 

Warning: fwrite(): supplied argument is not a valid stream resource in /home/[user name]/public_html/catalog/admin/bizrate.php on line 283

 

Warning: fclose(): supplied argument is not a valid stream resource in /home/[user name]/public_html/catalog/admin/bizrate.php on line 284

FTP open connection failed to ftp.bizrate.com

 

Not sure what to do next. Suggestions welcome!

Share this post


Link to post
Share on other sites

Hello Guys,

I was hoping one of you could help me.

 

I have Ultimate SEO URL contribution, and i was wondering how could we make the feed show up with the modifyed URL,

I belive it will really help with the froogle ranking as the product will seem more relevent.

I hope you can help me,

 

Best

Yossi

Share this post


Link to post
Share on other sites

For some reason when I tried running a feed today I got this error:

 

: SQL error Unknown column 'products.manufacturers_id' in 'on clause'| sql = SELECT concat( 'http://grunionmoto.com/product_info.php?language=en&currency=USD&products_id=' ,products.products_id) AS product_url, products_model AS prodModel, products_weight, manufacturers.manufacturers_name AS mfgName, manufacturers.manufacturers_id, products.products_id AS id, products_description.products_name AS name, products_description.products_description AS description, products.products_quantity AS quantity, products.products_status AS prodStatus, FORMAT( IFNULL(specials.specials_new_products_price, products.products_price) * 1,2) AS price, CONCAT( 'http://grunionmoto.com/images/' ,products.products_image) AS image_url, products_to_categories.categories_id AS prodCatID, categories.parent_id AS catParentID, categories_description.categories_name AS catName FROM categories, categories_description, products, products_description, products_to_categories left join manufacturers on ( manufacturers.manufacturers_id = products.manufacturers_id ) left join specials on ( specials.products_id = products.products_id AND ( ( (specials.expires_date > CURRENT_DATE) OR (specials.expires_date = 0) ) AND ( specials.status = 1 ) ) ) WHERE products.products_id=products_description.products_id AND products.products_id=products_to_categories.products_id AND products_to_categories.categories_id=categories.categories_id AND categories.categories_id=categories_description.categories_id AND products.products_status != 0 AND products.products_price != 0 AND products.products_price != '' AND products_description.language_id = '1' AND products_description.language_id = '1' AND categories_description.language_id = '1' ORDER BY products.products_id ASC

 

I dont remember changing anything.... I found someone else with this error but I do not know how to find and modify my sql. Anyone have any suggestions they can offer?

Share this post


Link to post
Share on other sites

Hi, I just installed Automatic Store Feeder V3.3 onto osc rc2a.

 

Well I run store feed i am getting the following error:

 

File completed: froogle_us_file.txt

Connected to uploads.google.com, for user simon_mobile604

 

Warning: ftp_put() [function.ftp-put]: php_connect_nonb() failed: Connection timed out (110) in /home/simon/public_html/develop/admin/froogle_us.php on line 497

 

Warning: ftp_put() [function.ftp-put]: Type set to A. in /home/simon/public_html/develop/admin/froogle_us.php on line 497

uploads.google.com: FTP upload has failed!

 

Script timer: 48.705497 seconds.

 

 

 

Anyone know what the problem is?

Share this post


Link to post
Share on other sites

Hello,

i`ve installed this contrib but i get this error if I click on Froogle_de (in the Store Feeds).

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/httpd/vhosts/mediab-limburg.de/httpdocs/admin/froogle_de.php:1) in /home/httpd/vhosts/mediab-limburg.de/httpdocs/admin/includes/functions/sessions.php on line 102

File completed: froogle.txt

 

Fatal error: Call to undefined function: ftp_connect() in /home/httpd/vhosts/mediab-limburg.de/httpdocs/admin/froogle_de.php on line 466

 

What I`ve done wrong?

Share this post


Link to post
Share on other sites

Hi,

 

After installing this cintribution it sends the Feeds to Froogle via FTP fine, however, running the Deutsch Froogle file doesnt create any entries in the file, why would this happen?

 

Also, Froogle keeps telling me that my froogle_us.php and UK file contain errors due to the fact that I am using attributes that are no longer supported. Does anyone else have this problem, I think the files need to be updated to use the new attributes, but I dont know how to do this.

Share this post


Link to post
Share on other sites
For some reason when I tried running a feed today I got this error:

 

: SQL error Unknown column 'products.manufacturers_id' in 'on clause'| sql = SELECT concat( 'http://grunionmoto.com/product_info.php?language=en&currency=USD&products_id=' ,products.products_id) AS product_url, products_model AS prodModel, products_weight, manufacturers.manufacturers_name AS mfgName, manufacturers.manufacturers_id, products.products_id AS id, products_description.products_name AS name, products_description.products_description AS description, products.products_quantity AS quantity, products.products_status AS prodStatus, FORMAT( IFNULL(specials.specials_new_products_price, products.products_price) * 1,2) AS price, CONCAT( 'http://grunionmoto.com/images/' ,products.products_image) AS image_url, products_to_categories.categories_id AS prodCatID, categories.parent_id AS catParentID, categories_description.categories_name AS catName FROM categories, categories_description, products, products_description, products_to_categories left join manufacturers on ( manufacturers.manufacturers_id = products.manufacturers_id ) left join specials on ( specials.products_id = products.products_id AND ( ( (specials.expires_date > CURRENT_DATE) OR (specials.expires_date = 0) ) AND ( specials.status = 1 ) ) ) WHERE products.products_id=products_description.products_id AND products.products_id=products_to_categories.products_id AND products_to_categories.categories_id=categories.categories_id AND categories.categories_id=categories_description.categories_id AND products.products_status != 0 AND products.products_price != 0 AND products.products_price != '' AND products_description.language_id = '1' AND products_description.language_id = '1' AND categories_description.language_id = '1' ORDER BY products.products_id ASC

 

I dont remember changing anything.... I found someone else with this error but I do not know how to find and modify my sql. Anyone have any suggestions they can offer?

 

I'm getting this same error on every feed I run. I've installed according to directins, created logins and FTP accounts / directories as required - run through the many updates and sql updates. Failing the ability to get this working is there a simple uninstall option somewhere?

Share this post


Link to post
Share on other sites
Hi,

 

After installing this cintribution it sends the Feeds to Froogle via FTP fine, however, running the Deutsch Froogle file doesnt create any entries in the file, why would this happen?

 

Also, Froogle keeps telling me that my froogle_us.php and UK file contain errors due to the fact that I am using attributes that are no longer supported. Does anyone else have this problem, I think the files need to be updated to use the new attributes, but I dont know how to do this.

 

I'm having the same issues. I was able to get the US feed to work fine but UK and DE throw bad header and attribute errors. I compared the php files and they are the same - so no clue why US works but UK and Germany do not. It would appear this contribution is no longer supported or updated which sucks - it's a much needed one.

 

I tried disabling the various attributes UK and DE base complained about by setting option "0" in the advanced configuration section. This worked but then I started seeing errors about "too many tabs" in header......

 

The google base application for uploading feeds is also broken and no longer functions.

 

I've decided to see if I can get the RSS feed contribution to work as a Google base feeder. Google base seems to support RSS and RSS 2.0 now, apparently.

Share this post


Link to post
Share on other sites

Thanks for the help infotech, I look forward to hearing about how the RSS feed goes. I believe froogle operates in other countries too (other than UK, US and DE) these are things we really are failing to take advantage of with the current contribution.

 

Currently the majority of my sales come from Froogle and I really do need this contribution. Its basically a fastrack to the top of google, it's surprising that only a few businesses really take advantage of it. It is a shame that it appears that this contribution and similar are no longer supported it really could have been great, however, getting these contributions to work - let alone getting some discussion going as to whether there is a way to SEO our froogle feeds is out of the question due to the lack of support.

 

I hope you manage to get some progress with the RSS feed contribution, let me know how it goes!

 

Ben

Share this post


Link to post
Share on other sites

Please help!

I installed the contribution however I'm trying to download the file locally instead of send it to google via FTP, I want to upload it at goggle as a manual feed.

When I right click on the run feed for Froogle US, I get the file download screen but after a few seconds I get the following error:

 

Internet explorer cannot download from MYSITE.com

the file could not be written to the cache.

 

Any ideas or a suggestion on what I need to do to download the file locally to be able to modify it if needed.

 

 

In advance thanks for any help I can get.

Share this post


Link to post
Share on other sites
I'm having the same issues. I was able to get the US feed to work fine but UK and DE throw bad header and attribute errors. I compared the php files and they are the same - so no clue why US works but UK and Germany do not. It would appear this contribution is no longer supported or updated which sucks - it's a much needed one.

 

I tried disabling the various attributes UK and DE base complained about by setting option "0" in the advanced configuration section. This worked but then I started seeing errors about "too many tabs" in header......

 

The google base application for uploading feeds is also broken and no longer functions.

 

I've decided to see if I can get the RSS feed contribution to work as a Google base feeder. Google base seems to support RSS and RSS 2.0 now, apparently.

 

 

Hi

 

I was just wondering if you had managed to progess any further with your adaptation of the RSS feed contribution to work with Froogle?

 

Thanks!

 

Ben

Share this post


Link to post
Share on other sites

hi every1

i am new to oscommerce but i have learnd lot frm community support.

firstable thanks for the Automatic Store Feeds.

i have installed store feeds v3.3, as far as i am concern i have followd the instruction but wen i log in to my admin section and tri to "run feed" it shows an error..

 

File completed: froogle_uk_file.txt

 

Fatal error: Call to undefined function ftp_connect() in /home/buyersislauk/public_html/admin/froogle_uk.php on line 461

 

 

froogle_uk.php on line 461 its showing: $conn_id = ftp_connect($ftpservername);

 

i hav an account wit foogle nd yahoo.

can any1 kindly help me

thanks in advance

mab

Share this post


Link to post
Share on other sites

Hello ,

 

i was wondering if anyone could give me some advice or a hand in getting this to work ?

 

i have got it to work to the point , that it goes from my site to google base , but google base does not insert it and gives me errors

 

Failed

Data feed upload failed. No items are live.

 

sorry for the long post. i upgraded to lastest version of Automatic store feed 3.3b , any advice is welcome in the past we have paid out people to get this working and they have left us with a version that did not work..

 

any advice is welcome.

 

 

We didn't understand the header (first) row of your file. Please make sure you're using valid attribute names. help ship_to

1

This attribute is no longer supported. Please use a supported attribute. help language

1

We didn't understand the header (first) row of your file. Please make sure you're using valid attribute names. help model

1

This attribute is no longer supported. Please use a supported attribute. help instock

1

This attribute is no longer supported. Please use a supported attribute. help label

1

We recommend including this attribute. help upc

 

We recommend including this attribute. help mpn

 

We recommend including this attribute. help isbn

 

We recommend including this attribute. help image link

 

We recommend including this attribute. help brand

 

We didn't understand this location. help location:Address of the items's location here

178

The item is missing a required attribute. help description

333

We didn't understand this location. help location:Address of the items's location here

691

We didn't understand this location. help location:Address of the items's location here

945

We didn't understand this location. help location:Address of the items's location here

345

We didn't understand this location. help location:Address of the items's location here

622

We didn't understand this location. help location:Address of the items's location here

905

We didn't understand this location. help location:Address of the items's location here

735

We didn't understand this location. help location:Address of the items's location here

545

We didn't understand this location. help location:Address of the items's location here

907

We didn't understand this location. help location:Address of the items's location here

748

We didn't understand this location. help location:Address of the items's location here

512

We didn't understand this location. help location:Address of the items's location here

716

The item is missing a required attribute. help description

116

We didn't understand this location. help location:Address of the items's location here

816

We didn't understand this location. help location:Address of the items's location here

471

We didn't understand this location. help location:Address of the items's location here

775

We didn't understand this location. help location:Address of the items's location here

595

We didn't understand this location. help location:Address of the items's location here

858

We didn't understand this location. help location:Address of the items's location here

899

We didn't understand this location. help location:Address of the items's location here

711

The item is missing a required attribute. help description

269

We didn't understand this location. help location:Address of the items's location here

875

We didn't understand this location. help location:Address of the items's location here

915

We didn't understand this location. help location:Address of the items's location here

921

The item is missing a required attribute. help description

79

You provide nothing for the attribute. help description:

79

We didn't understand this location. help location:Address of the items's location here

206

The item is missing a required attribute. help description

608

The item is missing a required attribute. help description

44

We didn't understand this location. help location:Address of the items's location here

838

The item is missing a required attribute. help description

180

The item is missing a required attribute. help description

307

We didn't understand this location. help location:Address of the items's location here

370

We didn't understand this location. help location:Address of the items's location here

714

We didn't understand this location. help location:Address of the items's location here

5

We didn't understand this location. help location:Address of the items's location here

725

We didn't understand this location. help location:Address of the items's location here

526

The item is missing a required attribute. help description

82

The item is missing a required attribute. help description

228

We didn't understand this location. help location:Address of the items's location here

485

We didn't understand this location. help location:Address of the items's location here

645

We didn't understand this location. help location:Address of the items's location here

824

We didn't understand this location. help location:Address of the items's location here

490

The item is missing a required attribute. help description

280

We didn't understand this location. help location:Address of the items's location here

493

The item is missing a required attribute. help description

415

We didn't understand this location. help location:Address of the items's location here

527

We didn't understand this location. help location:Address of the items's location here

570

The item is missing a required attribute. help description

148

We didn't understand this location. help location:Address of the items's location here

731

We didn't understand this location. help location:Address of the items's location here

738

The item is missing a required attribute. help description

453

The item is missing a required attribute. help description

371

We didn't understand this location. help location:Address of the items's location here

500

The item is missing a required attribute. help description

393

The item is missing a required attribute. help description

272

We didn't understand this location. help location:Address of the items's location here

367

We didn't understand this location. help location:Address of the items's location here

551

We didn't understand this location. help location:Address of the items's location here

553

We didn't understand this location. help location:Address of the items's location here

874

We didn't understand this location. help location:Address of the items's location here

712

The item is missing a required attribute. help description

50

The item is missing a required attribute. help description

61

The item is missing a required attribute. help description

383

The item is missing a required attribute. help description

320

We didn't understand this location. help location:Address of the items's location here

611

The item is missing a required attribute. help description

96

We didn't understand this location. help location:Address of the items's location here

606

The item is missing a required attribute. help description

347

The item is missing a required attribute. help description

151

The item is missing a required attribute. help description

224

The item is missing a required attribute. help description

94

We didn't understand this location. help location:Address of the items's location here

814

We didn't understand this location. help location:Address of the items's location here

402

The item is missing a required attribute. help description

219

We didn't understand this location. help location:Address of the items's location here

710

We didn't understand this location. help location:Address of the items's location here

226

We didn't understand this location. help location:Address of the items's location here

761

We didn't understand this location. help location:Address of the items's location here

541

We didn't understand this location. help location:Address of the items's location here

917

The item is missing a required attribute. help description

295

We didn't understand this location. help location:Address of the items's location here

783

We didn't understand this location. help location:Address of the items's location here

702

The item is missing a required attribute. help description

184

We didn't understand this location. help location:Address of the items's location here

499

The item is missing a required attribute. help description

391

We didn't understand this location. help location:Address of the items's location here

597

We didn't understand this location. help location:Address of the items's location here

661

We didn't understand this location. help location:Address of the items's location here

411

We didn't understand this location. help location:Address of the items's location here

567

We didn't understand this location. help location:Address of the items's location here

384

We didn't understand this location. help location:Address of the items's location here

351

The item is missing a required attribute. help description

210

We didn't understand this location. help location:Address of the items's location here

304

We didn't understand this location. help location:Address of the items's location here

362

We didn't understand this location. help location:Address of the items's location here

263

The item is missing a required attribute. help description

49

The item is missing a required attribute. help description

649

We didn't understand this location. help location:Address of the items's location here

543

We didn't understand this location. help location:Address of the items's location here

897

We didn't understand this location. help location:Address of the items's location here

789

The item is missing a required attribute. help description

138

The item is missing a required attribute. help description

392

We didn't understand this location. help location:Address of the items's location here

498

The item is missing a required attribute. help description

153

We didn't understand this location. help location:Address of the items's location here

109

We didn't understand this location. help location:Address of the items's location here

859

We didn't understand this location. help location:Address of the items's location here

216

We didn't understand this location. help location:Address of the items's location here

616

We didn't understand this location. help location:Address of the items's location here

574

We didn't understand this location. help location:Address of the items's location here

326

We didn't understand this location. help location:Address of the items's location here

308

The item is missing a required attribute. help description

302

We didn't understand this location. help location:Address of the items's location here

732

The item is missing a required attribute. help description

110

We didn't understand this location. help location:Address of the items's location here

934

The item is missing a required attribute. help description

521

We didn't understand this location. help location:Address of the items's location here

638

We didn't understand this location. help location:Address of the items's location here

674

We didn't understand this location. help location:Address of the items's location here

637

The item is missing a required attribute. help description

476

We didn't understand this location. help location:Address of the items's location here

240

The item is missing a required attribute. help description

171

We didn't understand this location. help location:Address of the items's location here

539

We didn't understand this location. help location:Address of the items's location here

442

We didn't understand this location. help location:Address of the items's location here

948

The item is missing a required attribute. help description

319

The item is missing a required attribute. help description

358

The item is missing a required attribute. help description

64

We didn't understand this location. help location:Address of the items's location here

652

The item is missing a required attribute. help description

389

We didn't understand this location. help location:Address of the items's location here

135

The item is missing a required attribute. help description

335

The item is missing a required attribute. help description

337

The item is missing a required attribute. help description

99

We didn't understand this location. help location:Address of the items's location here

820

The item is missing a required attribute. help description

104

The item is missing a required attribute. help description

111

We didn't understand this location. help location:Address of the items's location here

779

We didn't understand this location. help location:Address of the items's location here

881

We didn't understand this location. help location:Address of the items's location here

852

We didn't understand this location. help location:Address of the items's location here

851

We didn't understand this location. help location:Address of the items's location here

509

We didn't understand this location. help location:Address of the items's location here

753

We didn't understand this location. help location:Address of the items's location here

482

The item is missing a required attribute. help description

426

We didn't understand this location. help location:Address of the items's location here

654

We didn't understand this location. help location:Address of the items's location here

68

We didn't understand this location. help location:Address of the items's location here

380

We didn't understand this location. help location:Address of the items's location here

343

We didn't understand this location. help location:Address of the items's location here

876

The item is missing a required attribute. help description

309

The item is missing a required attribute. help description

382

We didn't understand this location. help location:Address of the items's location here

531

We didn't understand this location. help location:Address of the items's location here

682

We didn't understand this location. help location:Address of the items's location here

119

We didn't understand this location. help location:Address of the items's location here

705

We didn't understand this location. help location:Address of the items's location here

685

We didn't understand this location. help location:Address of the items's location here

286

We didn't understand this location. help location:Address of the items's location here

518

We didn't understand this location. help location:Address of the items's location here

200

We didn't understand this location. help location:Address of the items's location here

563

We didn't understand this location. help location:Address of the items's location here

250

We didn't understand this location. help location:Address of the items's location here

618

We didn't understand this location. help location:Address of the items's location here

28

We didn't understand this location. help location:Address of the items's location here

729

The item is missing a required attribute. help description

298

We didn't understand this location. help location:Address of the items's location here

734

The item is missing a required attribute. help description

427

We didn't understand this location. help location:Address of the items's location here

707

We didn't understand this location. help location:Address of the items's location here

723

The item is missing a required attribute. help description

352

The item is missing a required attribute. help description

81

We didn't understand this location. help location:Address of the items's location here

215

We didn't understand this location. help location:Address of the items's location here

900

We didn't understand this location. help location:Address of the items's location here

795

We didn't understand this location. help location:Address of the items's location here

741

The item is missing a required attribute. help description

242

We didn't understand this location. help location:Address of the items's location here

863

We didn't understand this location. help location:Address of the items's location here

237

The item is missing a required attribute. help description

238

We didn't understand this location. help location:Address of the items's location here

117

The item is missing a required attribute. help description

315

The item is missing a required attribute. help description

327

We didn't understand this location. help location:Address of the items's location here

378

The item is missing a required attribute. help description

802

The item is missing a required attribute. help description

181

The item is missing a required attribute. help description

797

We didn't understand this location. help location:Address of the items's location here

175

Share this post


Link to post
Share on other sites

I went and changed some settings and i have managed to get the items to load into google base , some of my products dont have descriptions , is there a way i can upload with having to put in a description ? or do all items need descriptions?

 

thanks

 

again sorry about the big post.

Edited by toefinger

Share this post


Link to post
Share on other sites
I went and changed some settings and i have managed to get the items to load into google base , some of my products dont have descriptions , is there a way i can upload with having to put in a description ? or do all items need descriptions?

 

thanks

 

again sorry about the big post.

 

Toefinger, I received the same error today aswell.

 

Here's what mine said:

 

We did not understand the header (first) row of your file. Please make sure that you are using valid attribute names. help ship_to

1

This attribute is no longer supported. Please use a supported attribute. help language

1

We did not understand the header (first) row of your file. Please make sure that you are using valid attribute names. help model

1

This attribute is no longer supported. Please use a supported attribute. help instock

1

This attribute is no longer supported. Please use a supported attribute. help label

1

We recommend including this attribute. help mpn

 

We recommend including this attribute. help isbn

 

We recommend including this attribute. help ean

 

We recommend including this attribute. help brand

 

We did not understand this location. help location:Address of the items's location here

15

We did not understand this location. help location:Address of the items's location here

9

We did not understand this location. help location:Address of the items's location here

35

We did not understand this location. help location:Address of the items's location here

26

We did not understand this location. help location:Address of the items's location here

16

We did not understand this location. help location:Address of the items's location here

22

We did not understand this location. help location:Address of the items's location here

3

We did not understand this location. help location:Address of the items's location here

36

We did not understand this location. help location:Address of the items's location here

28

We did not understand this location. help location:Address of the items's location here

25

We did not understand this location. help location:Address of the items's location here

4

We did not understand this location. help location:Address of the items's location here

31

We did not understand this location. help location:Address of the items's location here

32

We did not understand this location. help location:Address of the items's location here

23

We did not understand this location. help location:Address of the items's location here

20

We did not understand this location. help location:Address of the items's location here

19

We did not understand this location. help location:Address of the items's location here

11

We did not understand this location. help location:Address of the items's location here

5

We did not understand this location. help location:Address of the items's location here

39

We did not understand this location. help location:Address of the items's location here

30

We did not understand this location. help location:Address of the items's location here

18

We did not understand this location. help location:Address of the items's location here

34

We did not understand this location. help location:Address of the items's location here

21

We did not understand this location. help location:Address of the items's location here

29

We did not understand this location. help location:Address of the items's location here

2

We did not understand this location. help location:Address of the items's location here

12

We did not understand this location. help location:Address of the items's location here

7

We did not understand this location. help location:Address of the items's location here

14

We did not understand this location. help location:Address of the items's location here

38

We did not understand this location. help location:Address of the items's location here

8

We did not understand this location. help location:Address of the items's location here

13

We did not understand this location. help location:Address of the items's location here

27

We did not understand this location. help location:Address of the items's location here

6

We did not understand this location. help location:Address of the items's location here

17

We did not understand this location. help location:Address of the items's location here

33

We did not understand this location. help location:Address of the items's location here

10

We did not understand this location. help location:Address of the items's location here

37

We did not understand this location. help location:Address of the items's location here

24

Share this post


Link to post
Share on other sites
Toefinger, I received the same error today aswell.

 

Here's what mine said:

 

Hey ,

 

i will try and help you , if you go into the froogle_uk.php or what ever one your using

 

and edit the lines ..

 

$location = 1;

$default_location = "CITY, COUNTY, COUNTRY"; // Addresses should be formatted as: street, city, state, postal code, country. Each location element should be separated by a comma.

 

and change the words CITY , COUNTY , COUNTRY to where ever you are so for example if you lived in london

 

it would read

 

$location = 1;

$default_location = "London, L1 8jp, UK"; // Addresses should be formatted as: street, city, state, postal code, country. Each location element should be separated by a comma.

 

hope that helps...

Share this post


Link to post
Share on other sites
Hey ,

 

i will try and help you , if you go into the froogle_uk.php or what ever one your using

 

and edit the lines ..

 

$location = 1;

$default_location = "CITY, COUNTY, COUNTRY"; // Addresses should be formatted as: street, city, state, postal code, country. Each location element should be separated by a comma.

 

and change the words CITY , COUNTY , COUNTRY to where ever you are so for example if you lived in london

 

it would read

 

$location = 1;

$default_location = "London, L1 8jp, UK"; // Addresses should be formatted as: street, city, state, postal code, country. Each location element should be separated by a comma.

 

hope that helps...

 

Hi Toefinger, thanks for the response.

 

I've looked through the froogle_uk_file.txt but couldn't find any similar code, where abouts it the file located?

 

Thanks!

Share this post


Link to post
Share on other sites

Hi

 

Currently on my site the quantity for all items is 0. Google have informed me that for my feed of products to be approved the quantity needs to be higher than 0. Is there a way to edit this contribution so that it populates Googles Quantity field with a number (ie. 10) ?

 

 

Thanks,

 

Ben

Share this post


Link to post
Share on other sites

I was having problems with my product feeds not accepting at froogle us, so I went into the froogle_us.php file under admin and turned the advanced options off.

Share this post


Link to post
Share on other sites
Hi Mushindo,

 

Thanks for this contribution. It works well for me.

 

I've slightly modified it to run on a shop for Google Base US and for Google Base UK, with the required currencies and it works perfectly for me.

 

Now I'd love to make a feed for Google DE, since this shop is also in German. But the description indeed needs to be in German.

 

Would you know how to modify the code to pick up the descriptions in another language?

 

 

It could also be integrated into the next version of this contribution. Ideally a few variab les could be added at the beginning of the file (like it is presently done for the currency), e.g.:

 

$other_language = true; // Use another language than the default one. Default = false

$language = "de"; // Use that language if $other_language is true.

 

 

 

Thanks,

 

-Ben

 

Hello ben

I saw that ur contribution worked fine...i am getting an error could please tell me where i went wrong

 

: SQL error Unknown column 'products.manufacturers_id' in 'on clause'| sql = SELECT concat( 'http://www.sportsuk.co.cc/product_info.php?language=en&currency=USD&products_id=' ,products.products_id) AS product_url, products_model AS prodModel, products_weight, manufacturers.manufacturers_name AS mfgName, manufacturers.manufacturers_id, products.products_id AS id, products_description.products_name AS name, products_description.products_description AS description, products.products_quantity AS quantity, products.products_status AS prodStatus, FORMAT( IFNULL(specials.specials_new_products_price, products.products_price) * 1,2) AS price, CONCAT( 'http://www.sportsuk.co.cc/images/' ,products.products_image) AS image_url, products_to_categories.categories_id AS prodCatID, categories.parent_id AS catParentID, categories_description.categories_name AS catName FROM categories, categories_description, products, products_description, products_to_categories left join manufacturers on ( manufacturers.manufacturers_id = products.manufacturers_id ) left join specials on ( specials.products_id = products.products_id AND ( ( (specials.expires_date > CURRENT_DATE) OR (specials.expires_date = 0) ) AND ( specials.status = 1 ) ) ) WHERE products.products_id=products_description.products_id AND products.products_id=products_to_categories.products_id AND products_to_categories.categories_id=categories.categories_id AND categories.categories_id=categories_description.categories_id AND products.products_status != 0 AND products.products_price != 0 AND products.products_price != '' AND products_description.language_id = '1' AND products_description.language_id = '1' AND categories_description.language_id = '1' ORDER BY products.products_id ASC 

Share this post


Link to post
Share on other sites

Thanks for the great contribution.

 

After reading this thread I was able to successfully install this contribution to my store and every thing works perfect.

 

My problem is that I have java code after every description that I will like to leave out.

 

Example

 

Description

Maid 4 You costume includes a mini lace trimmed apron with back tie closure matching high thigh style lace panty lace choker lace wristlets and lace garter.

Size: Free Size Material: 100% Polyamide Fiber Colors: Black/White.

 

Java code >> begin

var win= null; function NewWindow(mypage myname w h scroll){ var winl = (screen.width-w)/2; var wint = (screen.height-h)/2; var settings =\'height=\'+h+\' \'; settings +=\'width=\'+w+\' \'; settings +=\'top=\'+wint+\' \'; settings +=\'left=\'+winl+\' \'; settings +=\'scrollbars=no\'; settings +=\'resizable=no\'; win=window.open(mypage myname settings); if(parseInt(navigator.appVersion) > = 4){win.window.focus();} } Size Chart

 

java code. >> End

 

 

I am a novice I will like to modify froogle_us.php so it does not add the java code to

Description any help will be really appreciated.

 

BTW I am using:

Add additional text to title, description and url in your feeds by - azcustomshirts - 19 Jul 2007

 

http://www.oscommerce.com/community/contributions,4455

 

 

Thanks in advance

Share this post


Link to post
Share on other sites

Aly Mirza

 

Just use Automated Store Feeds v3.3b this will slove your problem

 

___________________________________________________

 

****Automated Store Feeds v3.3b***

 

Updated SQL to work with MySQL 5.x.

 

Just needed some extra parenthesis around FROM statements.

 

Package only includes changed files.

____________________________________________________________

 

Your sever is MYSQL 5x v3.3b will take care of that

Share this post


Link to post
Share on other sites

hi,

 

i would like to install this contributiuon, however before i even start i can see that the contributions have been messed up,

 

the majority of the latter versions only contain update PHP files, none contain installation scripts or sql updates

 

i wish everyone would ensure that full packages are included....

 

a question to anyone that has succesfuly installed this contrib.

 

which file is the starting point that will then allow me to install the latest updates (3.3b) + the yahoo fixes afterwards

 

thanks

Share this post


Link to post
Share on other sites

Hello Jim,

 

The add-on is installed very well and I have seen the right feed.txt on my website.

 

After add this feed on google base, I find these problems:

 

1. when I choose schedule, I do not know when it is ok for google to proceed although I have added the feed for 24 hours.

 

2. I use the Manual:upload file but it shows Disapproved and no further error indication.

 

The file I get is just copy all the content on www.xxx.com/feed.txt and save it to a new document named feed.txt

 

Thanks!

 

Alex

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×