problem with google shopping export

07.10.2013 09:42
#1
gallery
User gallery
Name: ariya
25.06.2011
Posts: 120
Quote
problem with google shopping export

Hi
i have bought and using google shopping export on joomla 2.5 the feed is exporting correctly but all the product (publish & unpublished ) are in the feed .even though i unpublished some shop category, the remaining published category are shown in ,category compare , but after exporting the feed ,,feed contain all product belong to published and unpublished category ,by this problem we can not submit selected product to google shopping ,and deleting no need product from feed is impossible when you have more than 2000 product on shop,
is there any way to solve this problem
thanks in advance
regards
ariyagallery


Joomla: 2.5.7
JoomShopping: 3.4.2
PHP: php 5.4
Website Url: http://www.ariya-carpet.co.jp
 
07.10.2013 13:39
#2
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16493
Quote
Aw: problem with google shopping export

Did not understand the problem
very confusing description

 
07.10.2013 15:55
#3
gallery
User gallery
Name: ariya
25.06.2011
Posts: 120
Quote
Aw: problem with google shopping export

dear admin
hi
simple des : google shopping feed contain all product ( published and unpublished product )
i need google shopping feed show ( contain ) only published poduct
more easy than this
regards
ariyagallery

 
07.10.2013 16:04
#4
gallery
User gallery
Name: ariya
25.06.2011
Posts: 120
Quote
Aw: problem with google shopping export

dear admin
the same as for product in unpublished category
i need feed contain only product that are published
now is showing products that are not published ( showing all published and unpublished product )
show product from a category which that category is unpublised
feed means product which you want to sell , if showing product which you do not have ( and unpublished that )
something must be wrrong
waiting for reply
regards
ariyagallery

 
07.10.2013 16:52
#5
gallery
User gallery
Name: ariya
25.06.2011
Posts: 120
Quote
Aw: problem with google shopping export

dear admin
feed need to show published product
no need unpublished product
no need poduct in unpublished category
only published product in published category that is all
do you need more explanatiion ? i dont think so
waiting for your reply
regards
ariyagallery

 
07.10.2013 18:10
#6
gallery
User gallery
Name: ariya
25.06.2011
Posts: 120
Quote
Aw: problem with google shopping export

waiting for reply
google have warned me to close my account becouse i have maney unpublished product in my feed ( causing 404 error url)
what to do to have only published product in feed
unpatiently waiting for admin answer
regards
ariyagallery

 
07.10.2013 21:42
#7
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16493
Quote
Aw: problem with google shopping export

will be filter in new version.

 
08.10.2013 09:12
#8
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16493
Quote
Aw: problem with google shopping export

Install "Addon Google export 4.3.0" / new option

 
08.10.2013 10:39
#9
gallery
User gallery
Name: ariya
25.06.2011
Posts: 120
Quote
Aw: problem with google shopping export

dear admin
thanks for your reply
so first i need to upgrade my shop to 3.7.0 or higher
i will do and see the results
thank
regards
ariyagallery

 
08.10.2013 11:36
#10
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16493
Quote
Aw: problem with google shopping export

Try chnage file
administrator\components\com_jshopping\importexport\googleproductexport\googleproductexport.php

code

LEFT JOIN `#__jshopping_delivery_times` AS dt ON dt.id = prod.delivery_times_id
where prod.product_publish='1'

change to

LEFT JOIN `#__jshopping_delivery_times` AS dt ON dt.id = prod.delivery_times_id
LEFT JOIN `#__jshopping_categories` AS category ON category.`category_id` = categ.`category_id`
where prod.product_publish='1' AND category.`category_publish` = 1

 
Copyrights MAXXmarketing GmbH. All Rights Reserved