This is pretty much what I have been using all along for Google base export. It has a few modifications and I just quickly added the attribute “Availability” to get my products listed once again. The “Availability” is just a bandaid until I can figure out how to dynamically create the data depending on the quantity/amount.
Upload the attached file to the root of your store and extract.
[color=“#FF0000”]See post #29 for the latest version of the modification.[/color]
Thanks for this Tool!
Off the top of your head, do you know if this will also work for 2.1.4 Pro ?
No problem Struck.
Yes, it should work for all versions 2.x
Thanks for the mod! I'll have to try it out. Does it modify any of the core or does it use hooks? I'm honestly not for sure if you could even do this in hooks or not, I'm just curious.
There are no hooks…you just replace it and go. I wouldn't be concerned with it getting overwritten during upgrades because it appears CSC is abandoning it anyway.? It may be removed all together pretty soon.?
The wound has healed and the bandaid has been removed. Attached is my file with all of my modifications including the “Availability” attribute which will dynamically create “preorder” for quantities less than 0, “out of stock” for quantities equaling 0, and “in stock” for quantities greater than 0.
Upload to the root of your installation and extract.
[attachment=4586:googlebase_2.2.3_1.zip]
For those whom want the standard/stock file with the “Availability” attibute.
[attachment=4587:google.php]
[quote name='The Tool' timestamp='1317711725' post='122884']
The wound has healed and the bandaid has been removed. Attached is my file with all of my modifications including the “Availability” attribute which will dynamically create “preorder” for quantities less than 0, “out of stock” for quantities equaling 0, and “in stock” for quantities greater than 0.
Upload to the root of your installation and extract.
[attachment=4586:googlebase_2.2.3_1.zip]
For those whom want the standard/stock file with the “Availability” attibute.
[attachment=4587:google.php]
[/quote]
Hello,
Sorry, I'm new at this,do I upload the file in schemas/exim?
Thank you
[quote name='tom437' timestamp='1317824288' post='122961']
Hello,
Sorry, I'm new at this,do I upload the file in schemas/exim?
Thank you
[/quote]
The first one you extract in the root of installation. The second one you need to put in /schemas/exim
[quote name='The Tool' timestamp='1317832619' post='122971']
The first one you extract in the root of installation. The second one you need to put in /schemas/exim
[/quote]
Is this what is should look like?
because it still will not export to google base.
Check attachment[attachment=4596:is this right.jpg]
Could it be that, becuase I'm using 2.0.15 that why its not woking for me?
After adding the files google base tab disappear.
Any idea whay?
Anyone
From your image it appears you are in “Image export”. Try selecting the Google base export.
[quote name='The Tool' timestamp='1317894249' post='123020']
From your image it appears you are in “Image export”. Try selecting the Google base export.
[/quote]
The google base tab disappear from the tab where image and google base should be, after I added the files. It changed that part.
If I upgrade to the latest cscart, will that correct the problem?
Thanks
Tom
[quote name='The Tool' timestamp='1317686474' post='122867']
This is pretty much what I have been using all along for Google base export. It has a few modifications and I just quickly added the attribute “Availability” to get my products listed once again. The “Availability” is just a bandaid until I can figure out how to dynamically create the data depending on the quantity/amount.
Upload the attached file to the root of your store and extract.
[/quote]
Are you sure is this will work with 2.0.15 ?
No, I cannot say for sure if it works with 2.0.15 but it should. I have added the Availability attribute to the original file from 2.0.15.
Upload to the root of your installation and extract.
[attachment=4598:google_2.0.15.zip]
Thanks for this tool.
I have a question on it though:
Line 82: 'export_notice' => fn_get_lang_var('google_base_export_notice'),
Can anyone explain what value the google_base_export_notice variable should have and where is this shown?
Regards,
Vince
CSC added that recently. You can either remove that line or you can add the language in Administration->Languages
Variable: google_base_export_notice
Value: Note: You can setup Tax and Shipping rates on the Tax and shipping summary page in your Google merchant center.
[quote name='The Tool' timestamp='1317924390' post='123057']
No, I cannot say for sure if it works with 2.0.15 but it should. I have added the Availability attribute to the original file from 2.0.15.
Upload to the root of your installation and extract.
[attachment=4598:google_2.0.15.zip]
[/quote]
Thanks for the help, but I tried it, than tried to export to google and I got this
message.
Exporting data
Database error: Unknown column 'products.availability' in 'field list' (1054)
Invalid query: SELECT products.product_id, products.product_id as “id”, products.amount as “quantity”, products.availability, product_prices.price as “price”, products.product_code as “upc”, product_descriptions.product as “title”, product_descriptions.full_description as “description”, images_links.image_id as “image_link”, products.weight as “weight” FROM cscart_products as products LEFT JOIN cscart_product_descriptions as product_descriptions ON product_descriptions.product_id = products.product_id AND product_descriptions.lang_code = 'EN' LEFT JOIN cscart_product_prices as product_prices ON product_prices.product_id = products.product_id AND product_prices.lower_limit = '1' AND product_prices.usergroup_id = '0' LEFT JOIN cscart_images_links as images_links ON images_links.object_id = products.product_id AND images_links.object_type = 'product' AND images_links.type = 'M' WHERE products.status IN ('A') LIMIT 0, 30
Backtrace: File: /home/xxxxx/public_html/store/core/fn.database.php
Line: 310
Function: db_error
File: /home/xxxxx/public_html/store/core/fn.database.php
Line: 37
Function: db_query
File: /home/xxxxx/public_html/store/controllers/admin/exim.php
Line: 704
Function: db_get_array
File: /home/xxxxx/public_html/store/controllers/admin/exim.php
Line: 90
Function: fn_export
File: /home/xxxxx/public_html/store/core/fn.control.php
Line: 529
Function: include
File: /home/xxxxx/public_html/store/core/fn.control.php
Line: 392
Function: fn_run_controller
File: /home/xxxxx/public_html/store/xxxxx
Line: 27
Function: fn_dispatch
tom, I cannot diagnose your problem remotely and I have no trouble with the file. Is anyone else having problems with any of the files posted?
With the code I have added for availability, it should not be looking in the database for availability.
[quote name='The Tool' timestamp='1317953868' post='123091']
tom, I cannot diagnose your problem remotely and I have no trouble with the file. Is anyone else having problems with any of the files posted?
With the code I have added for availability, it should not be looking in the database for availability.
[/quote]
Thank you anyway.
But here is what I did, I extract the file and add it to schemas/exim.
Am I right?
No. You upload google_2.0.15.zip to the root of your installation then extract it. That's it.
I will say that the original file will still give you errors in Google base because it is not correct. You really need to use the google_2.2.3_1.zip if you do not want to get flagged by google.