Page 2 of 29

Re: [PAID] Google Merchant Static Feed

Posted: Sat Apr 09, 2011 7:45 pm
by Martin
Resolved the issue noted in the previous post.

1.1.6-beta is (will soon be) available via the BigCommerce site for existing customers.

Changelog
  • 1.1.6 : Revision 264
    • FIX: Force guest/default group permissions for product retrieval
      (Avoids potential for feed to include group specific/hidden products appearing in feed during manual generation)

Re: [PAID] Google Merchant Static Feed

Posted: Sat Apr 09, 2011 8:52 pm
by Martin
Found another bug...

Seems the SQL will pick up product records that include hidden categories but the category array was built from visible categories only. This resulted in a lot of empty Product "Type" lines in the feed if your store has a lot of hidden categories.

I've identified the problem and more or less written a fix but I'm not releasing ANOTHER version until I get some input back about the other fixes.


The new version will include a user settable variable: $include_hidden_categories which can be set to true or false.
Setting it to true will include the hidden categories associated with any visible products... False will result in only visible products and categories being shown.

Re: [PAID] Google Merchant Static Feed

Posted: Sat Apr 09, 2011 9:14 pm
by CharlieFoxtrot
The new version will include a user settable variable: $include_hidden_categories which can be set to true or false.
What if a product is cross-merchandised in BOTH a hidden category and visible category. ~ Will the fact that it appears in a hidden category prevent it from being included?

Re: [PAID] Google Merchant Static Feed

Posted: Sat Apr 09, 2011 11:38 pm
by Martin
CharlieFoxtrot wrote:
The new version will include a user settable variable: $include_hidden_categories which can be set to true or false.
What if a product is cross-merchandised in BOTH a hidden category and visible category. ~ Will the fact that it appears in a hidden category prevent it from being included?
It shouldn't... So long as there is one valid, visible category, the product should appear... The only time the product would "disappear" should/would be when it is solely within a group specific category or set !visible.

Re: [PAID] Google Merchant Static Feed

Posted: Sat Apr 09, 2011 11:40 pm
by Martin
Just as an aside on this... The fact that the "in stock" bug has now been located and resolved has actually had quite a dramatic effect on my feed performance in a matter of hours.

I'm guessing I've had a lot of products sitting as "Out of stock" thanks to the earlier feed not taking into account that "Track inventory" being off, meant "assume in stock"...

Better late than never I guess.

Re: [PAID] Google Merchant Static Feed

Posted: Sun Apr 10, 2011 10:54 am
by Martin
Right... another bug of sorts, to resolve...

The issue of category visibility is a bit of a pain as sub-categories don't get set as invisible if any parent category is non-visible... Currently working out the logic required to tackle this without risking uncontrolled loops and other silliness.

Re: [PAID] Google Merchant Static Feed

Posted: Sun Apr 10, 2011 2:54 pm
by Martin
Ok... Think that's sorted now..

The code now parses through the categories and works out which categories are viewable based on the catvisible (category visible) setting for itself and any parent/grand-parent/etc... categories above it.
  • If include_hidden_categories is true then it doesn't bother calculating it, it just includes the category information (as product "type") for any products that are linked to them whether they are hidden or not.
  • If include_hidden_categories is false, it determines the hierarchy of the categories, which would be visible or not and then provides only those categories that are "visible" as product "type" for listed products.
The code also interprets permissions for categories based on group access... This is not controlled by include_hidden_categories at all so any group specific categories will never show in the feed.

Re: [PAID] Google Merchant Static Feed

Posted: Sun Apr 10, 2011 3:00 pm
by Martin
New Version Release

Changelog
  • 1.1.7 : Revision 267
    • Categories apply view permission based on default/guest group
    • Properly hierarchy of visibility applied (parent/grandparent/etc.. category visibility affects child categories properly)
    • Applied limit to number of product "type" fields can appear (limit 10) as per Google Merchant 10 max values per attrib limits

Re: [PAID] Google Merchant Static Feed

Posted: Sun Apr 10, 2011 3:47 pm
by Martin
Not entirely sure whether to laugh maniacally, cry or just find a dark corner to curl up in and pretend the world doesn't exist...

Yes... Found ANOTHER bug... (gotta love it).

This one is ISC version specific and related to images...

I think Version 5.x will work fine with the current setup, but version 6.x with it's new approach to images means many products, created since the upgrade will no longer have an image with the listing.

Anyway... another version pending I guess... *looks for dark corner*

Re: [PAID] Google Merchant Static Feed

Posted: Sun Apr 10, 2011 4:52 pm
by Martin
Yet ANOTHER Version Release

Changelog
  • 1.1.8 : Revision 268
    • Added ISC database version detection function
    • Fix: Product image links now provided in feed for products added since ISC version 6.x