facebookarchive / Facebook-For-OpenCart

Facebook Ads integration with OpenCart
Other
72 stars 54 forks source link

The sync failure of your products to Facebook opencart 2.3 #81

Open pmrpoint opened 5 years ago

pmrpoint commented 5 years ago

The sync failure of your products to Facebook may be because of the large number of products on your system (We detected 78093 products). imperiumloft.ru - светильники, люстры, треки и многое другое по освещению_2018-12-28_09-32-21_facebook_ads_extension.log How to solve this problem? Is it possible to download the entire product? if not then how to unload certain categories?

shue249 commented 5 years ago

@pmrpoint Thanks for the feedback. We also see that you have file us a ticket via OpenCart support. Let us continue the discussion here.

We have received few other reports on this issue. Are you on a web hosting service? If so, the problem is probably due to the limited resources on the database when doing the initial pull of all products. There are some suggestions to try to mitigate this problem here https://github.com/facebookincubator/Facebook-For-OpenCart/issues/78.

shue249 commented 5 years ago

This is also another link for your reference https://github.com/facebookincubator/Facebook-For-OpenCart/issues/72

pmrpoint commented 5 years ago

I’m on the VPS server and it’s powerful, there are no restrictions on the formation of other types of uploads, only on Facebook. The best solution is to divide the download into 3-5 parts and upload it to Facebook. and also in modules there is such a graph http://prntscr.com/m0x2oh but when I switch to editing, it says that the page does not exist As I understand it, there are settings for unloading, and it turns out that I can not configure them. Is it possible to download only certain categories from the site, how to download parts? or not? only by increasing the server capacity? but I have a powerful VDS server.

pmrpoint commented 5 years ago

FACEBOOK PRODUCT QUERY BATCH COUNT - increased to 1000 and does not help

pmrpoint commented 5 years ago

This is also another link for your reference #72

someone will help me with a solution

shue249 commented 5 years ago

@pmrpoint Thank you for the feedback.

Our current plugin is splitting up the product list query into batches (hence the FACEBOOK PRODUCT QUERY BATCH COUNT) in order to generate the initial feed file. We may need some time to further look into this on how we can further optimise for really large catalog size on hosting services.

If you are familiar with SQL, you can attempt to make changes on the product query to restrict the product categories to be uploaded to Facebook. The code to make the changes is here https://github.com/facebookincubator/Facebook-For-OpenCart/blob/master/upload/admin/model/extension/facebookproduct.php#L67-L170

We do not support the Edit function of the plugin, hence it shows a "Page not found" when you click on the Edit button.

pmrpoint commented 5 years ago

Help me change the code to unload a category from the ID 333

pmrpoint commented 5 years ago

@pmrpoint Thank you for the feedback.

Our current plugin is splitting up the product list query into batches (hence the FACEBOOK PRODUCT QUERY BATCH COUNT) in order to generate the initial feed file. We may need some time to further look into this on how we can further optimise for really large catalog size on hosting services.

If you are familiar with SQL, you can attempt to make changes on the product query to restrict the product categories to be uploaded to Facebook. The code to make the changes is here https://github.com/facebookincubator/Facebook-For-OpenCart/blob/master/upload/admin/model/extension/facebookproduct.php#L67-L170

We do not support the Edit function of the plugin, hence it shows a "Page not found" when you click on the Edit button.

Help me change the code to unload a category from the ID 333

pmrpoint commented 5 years ago

@pmrpoint Thank you for the feedback.

Our current plugin is splitting up the product list query into batches (hence the FACEBOOK PRODUCT QUERY BATCH COUNT) in order to generate the initial feed file. We may need some time to further look into this on how we can further optimise for really large catalog size on hosting services.

If you are familiar with SQL, you can attempt to make changes on the product query to restrict the product categories to be uploaded to Facebook. The code to make the changes is here https://github.com/facebookincubator/Facebook-For-OpenCart/blob/master/upload/admin/model/extension/facebookproduct.php#L67-L170

We do not support the Edit function of the plugin, hence it shows a "Page not found" when you click on the Edit button.

my programmer says it will not work, I would like you to explain how to implement or what code to insert or change, I would be very grateful for the help