Facebook - eCommerce Catalog Browse [Support]

Hi solidrock

I am not completely sure what you mean. There should be a link in the left hand menu, this is the new facebook page layout since March. On older tabbed pages it should still appear as a tab.

If this doesn't help please send me a link to clarify the problem.

Thanks

The app has being running fine for a couple of day, but now is showing all of my items twice. Is there a way to clean everything and have it pull again?

Hi

You can clear the cache by going to the settings page in Facebook shop and clicking save. But I don't think this will solve the issue, please can you let me know your website so I can investigate the issue.

Cheers

Bright Software Solutions

The FB site is:
http://www.facebook.com/pages/AH-Accessoriescom/197133980325415

and the website is: https://www.ahaccessories.com

Thank you

Thank-you for the information, it appears that the products are appearing twice because the same product is available at two tax rates in the same tax class; 0% and 7%.

A simple fix would be to explicitly set it to only select the priority 1 tax rate.

e.g. Change line 200 in fb_browse.php
From
p.products_status=1
To
p.products_status=1 and tr.tax_priority=1

Hopefully this will resolve the problem and we will investigate how to update the add-on to automatically select the site default tax rate.

Sorry for the inconvenience,

Bright Software Solutions

I made the change and sure enough no more doubles, but now I have no products lol. That line modification eliminates or products from showing.

Said it would get rid of the duplicates! :blush:
Sorry, the line appears twice in the file, please restore the first one and only change the second instance where it appears.

Should look like this:

WHERE
p.products_status=1
and p.products_quantity>0 " . $query_Where . " order by " . $query_Order . $query_Limit;

Kind regards

Bright Software Solutions

Looks like we are good. Thank you:clap:

Hello, I have uploaded all files and when i go to signup inside the facebook app it takes me to your splash page

i dont see where to plug in my key nor do i see any setup screen

Sorry, for the confusion.

After installing the app a Bright Software Solutions sign-up page is displaying showing the product tariffs; at present there is only a FREE beta option.

On clicking the sign-up button, a Facebook permission pop-up appears. After accepting the permission pop-up, the app settings page (Admin Mode) appears, which allows you to enter the plugin key and your shop url.

Kind regards,

Bright Software Solutions

It seem like firefox browser isnt liking it

im using osx 10.5.8 and the latest firefox and when i click (online shop) on the left then click admin it goes to ur splash page

weird

but

when i use safari (on same mac) or a pc (xp pro) (with Firefox)
they both work goin to the setup screen to put key number in

that being said

now all i see is this

http://www.eye-dye.com/files/zensetupfb.png

do i have to catagorize my product in my zen cart to match

ok got product to show up

the website shop link was wrong in the setup page

Sorry, I have been out of the office today, but that's great news. I will also investigate the Mac issue to try and resolve the problem for future customers.

Cheers!

Hello, I am trying to install the Facebook mod and when I copy and paste the sql text and hit send, I get follwoing message

1048 Column 'configuration_group_id' cannot be null
in:
[INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Catalog Browser Plugin Key', 'BSS_PLUGIN_KEY', SUBSTRING(MD5(RAND()) FROM 1 FOR 9), 'This plugin key is used during Facebook Application setup, feel free to change this unique key a secure alternative if required.', @configuration_group_id, 0, NOW(), NULL, NULL);]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Any help or feedback is truly appreciated.

Thank You
Djace

It looks as though you may have missed a section of the SQL installation script.

The sql should be run as a complete script, as it should set the variable (@configuration_group_id) prior to running the script that errored. Please can you check whether the first part has installed by seeing if the configuration section has been installed.

This can be done via the admin; see if "Facebook Catalog Browser" is in the configuration menu. If so, get the configuration group ID from the URL and then replace the variable (@configuration_group_id) with the ID you have just copied.

e.g.

On my installation the URL (in my URL bar) is .../configuration.php?gID=39
The ID, in this case 39, should be use to replace @configuration_group_id in the script below:

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) 
VALUES (NULL, 'Catalog Browser Plugin Key', 'BSS_PLUGIN_KEY', SUBSTRING(MD5(RAND()) FROM 1 FOR 9), 'This plugin key is used during Facebook Application setup, feel free to change this unique key a secure alternative if required.', [B]@configuration_group_id[/B], 0, NOW(), NULL, NULL);

We also have the same problem with no categories or products showing like sco77m4r7in.

Its one of our customers, we have checked the link in the settings which is correct.

Any ideas?

http://www.facebook.com/pages/Horse-Supplements-Direct/179707775406400?sk=app_136002413133082

http://www.horsesupplementsdirect.co.uk

Hi,

Please can you check you have successfully uploaded the fb_browse.php file into the root of the your shop?

For some reason, when I try to visit the file directly (http://www.horsesupplementsdirect.co.uk/fb_browse.php?n=zc_browse&p=<PLUGINPASSWORD>) it returns the home page, rather than the json data feed normally returned by the add-on.

Cheers

Bright Software Solutions

Hello Brightsoftware,

Thank you for your quick response. I have restored my Zen cart data base to a previous state and then tried again from the begining to install the add on to my store.
However, I have again received the same error message intially as before. Then as you have pointed out I was able to see the Facebook browser installed under admin -> configuration.
My ID was same as in your example 39. Then I have replaced the "@configuration_group_id" with the number 39 and now I am able to see the auto generated KEY. :).
I wonder what could cause some parts of the script not to execute correctly, as I have copied entire text from the install file and pasted it into my store SQL window correctly.
So far so good I will now continue with the rst of the installation.
Thank you again,

djace

Okey guys,

I am trying to install the facebook app, and when I go to http://www.facebook.com/apps/application.php?id=136002413133082
page I don't see the "add to page" button link on the left hand side. Maybe I am just blind, can somebody point me in the right direction?
Thank you.

djace

Hi djace,

The link only appears if you have a Facebook page, the common mistake is people think a Facebook profile is the same as a business page.

The app is not designed for profile pages and would only be visible to the profile owner (which sort of defeats the point of this app!).

However you can convert a personal profile to a 'page' (used for businesses and public figures) whilst maintaining all your friends. The instructions for doing this can be found here:

http://www.facebook.com/help/?page=18918

After converting the 'profile' to a 'page', you should be able to install the app. Alternatively you can create a page from scratch via:

http://www.facebook.com/pages/create.php

Regards

Bright Software Solutions