Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

Facebook Feed rejected

 
Reply
   X-Cart forums > X-Cart 5 > Third Party Add-Ons for X-Cart 5
 
Thread Tools Search this Thread
  #1  
Old 08-24-2019, 11:20 PM
  amy2203's Avatar 
amy2203 amy2203 is offline
 

X-Wizard
  
Join Date: Jul 2004
Location: Watford, UK
Posts: 1,509
 

Default Facebook Feed rejected

I've just set up a facebook feed and all items are being rejected?

Incorrectly formatted property: price

The csv content when opened in Excel is:
£4.70 GBP

This should just be £4.70 for example.

How do I fix this?

I have checked the database and all the data is correct - and asked my host.

The data looks OK in Textwrangler when viewed as text, but inExcel shows the extra character.

I asked in the main forum and the advice was it's an encoding issue, but I can't work out where I can change the encoding of the feed.

All products are currently rejected by Facebook on the price.
__________________
X-Cart version 5 (Previously 3.5-4)

Previous Versions included
BCSE Reward Points Mod
Altered Cart On Sale Mod
Wordpress Plugin

Please don't PM me for support. I help where I can on the forum and your question will more likely be answered there.

Shout me a Coffee!
Reply With Quote
  #2  
Old 08-25-2019, 03:35 PM
  cflsystems's Avatar 
cflsystems cflsystems is offline
 

Veteran
  
Join Date: Apr 2007
Posts: 14,197
 

Default Re: Facebook Feed rejected

First of why are you using both £ and GBP? It should one or the other but not both. Or is this how the feed is exported by the module?
The currency is not something you will find in the database. The price is just a float number in the database. The currency and/or the symbol for the currency is something you will enter yourself in the settings in admin. So - have you checked that this setting is correctly entered?

 implies hidden symbol so you may not be able to see it in database or in simple text editor.

I would suggest you check the cart settings - currency setup - and you can even re-enter whatever is in there and re-save. Especially if you use the wizard to migrate from XC4 to XC5.

Also - don't trust much Excel for csv files. Excel is not a good choice for edit/view csv files.
OpenOffice Calc or better yet LibreOffice Calc is way way better.
__________________
Steve Stoyanov
CFLSystems.com
Web Development
Reply With Quote
  #3  
Old 08-26-2019, 08:43 AM
  amy2203's Avatar 
amy2203 amy2203 is offline
 

X-Wizard
  
Join Date: Jul 2004
Location: Watford, UK
Posts: 1,509
 

Default Re: Facebook Feed rejected

I think it's the way the module creates the csv file. My host has checked and all the database seems OK.

The currency is set up as the built in GBP Pound Sterling.

This was a new install not a migration from V4.
__________________
X-Cart version 5 (Previously 3.5-4)

Previous Versions included
BCSE Reward Points Mod
Altered Cart On Sale Mod
Wordpress Plugin

Please don't PM me for support. I help where I can on the forum and your question will more likely be answered there.

Shout me a Coffee!
Reply With Quote
  #4  
Old 08-26-2019, 03:33 PM
  cflsystems's Avatar 
cflsystems cflsystems is offline
 

Veteran
  
Join Date: Apr 2007
Posts: 14,197
 

Default Re: Facebook Feed rejected

Does this happen after you manipulate the file with Excel or is it on opening with Excel when you see it?

You can file a bug report with QT if you are sure it is the module. At the very least the price should not have both the symbol and the text for currency.

You can upload the csv file as exported by the cart, maybe someone can check on it and see if there is anything.
__________________
Steve Stoyanov
CFLSystems.com
Web Development
Reply With Quote
  #5  
Old 08-27-2019, 09:01 AM
  amy2203's Avatar 
amy2203 amy2203 is offline
 

X-Wizard
  
Join Date: Jul 2004
Location: Watford, UK
Posts: 1,509
 

Default Re: Facebook Feed rejected

It's as it exports from the module, i don't manipulate it, just open in Excel and see it.

i opened a ticket with x-cart a few days ago, I'm waiting on a reply.

Thanks,
__________________
X-Cart version 5 (Previously 3.5-4)

Previous Versions included
BCSE Reward Points Mod
Altered Cart On Sale Mod
Wordpress Plugin

Please don't PM me for support. I help where I can on the forum and your question will more likely be answered there.

Shout me a Coffee!
Reply With Quote
  #6  
Old 08-27-2019, 10:37 AM
  cflsystems's Avatar 
cflsystems cflsystems is offline
 

Veteran
  
Join Date: Apr 2007
Posts: 14,197
 

Default Re: Facebook Feed rejected

you have not uploaded any file in here
__________________
Steve Stoyanov
CFLSystems.com
Web Development
Reply With Quote
  #7  
Old 08-27-2019, 10:03 PM
  amy2203's Avatar 
amy2203 amy2203 is offline
 

X-Wizard
  
Join Date: Jul 2004
Location: Watford, UK
Posts: 1,509
 

Default Re: Facebook Feed rejected

Here's the latest file, freshly downloaded this morning.

Thank you
Attached Files
File Type: csv main_feed (2).csv (71.5 KB, 1059 views)
__________________
X-Cart version 5 (Previously 3.5-4)

Previous Versions included
BCSE Reward Points Mod
Altered Cart On Sale Mod
Wordpress Plugin

Please don't PM me for support. I help where I can on the forum and your question will more likely be answered there.

Shout me a Coffee!
Reply With Quote
  #8  
Old 08-28-2019, 06:30 AM
 
welly welly is offline
 

eXpert
  
Join Date: Mar 2011
Location: UK
Posts: 209
 

Default Re: Facebook Feed rejected

I am by no means an expert in this, but I do use this feed and the same currency without seeing these issues. The issues I'm having are different, but they do not lead to any products being rejected.

In admin, if I check under Store Setup, Localization, Currency, my settings are:

Store currency - GBP - Pound Sterling
Format - 1234.99
Prefix - £
Suffix - (nothing)

Are yours the same?

In my feed file, even in excel, there is no '£' symbol or special character, but 'GBP' is present.

Also, in Facebook business manager, I think you can see some of the products that are causing errors, and some examples of the values that Facebook doesn't like. Does that indicate a special character in your price field (leaving Excel out of the equation)?

Welly
__________________
X-Cart Business 5.3.6
Various add-ons

www.traininglines.co.uk
Reply With Quote
  #9  
Old 08-28-2019, 06:32 AM
  cflsystems's Avatar 
cflsystems cflsystems is offline
 

Veteran
  
Join Date: Apr 2007
Posts: 14,197
 

Default Re: Facebook Feed rejected

There is nothing wrong with the file.
I had it open in editor and there is no extra symbol. Opened it in LibreOffice and there is no extra symbol.
Even re-saved the file from LibreOffice back to csv and there is still no extra symbol - see attached.
This extra character is coming from your Excel when you open the file in there and if you re-save it it sticks. Don't use Excel for csv files. Excel highly depends on your OS settings when it is working with csv files.
Most likely the encoding is incorrect.


The only incorrect thing I see with this file is the use of symbol and code for currency - it has to be one or the other.
Attached Files
File Type: csv main_feed.csv (73.2 KB, 1045 views)
__________________
Steve Stoyanov
CFLSystems.com
Web Development
Reply With Quote
  #10  
Old 08-28-2019, 07:48 AM
  amy2203's Avatar 
amy2203 amy2203 is offline
 

X-Wizard
  
Join Date: Jul 2004
Location: Watford, UK
Posts: 1,509
 

Default Re: Facebook Feed rejected

Thanks. I don't usually open it in excel. Facebook takes the feed directly and is rejecting it. I only opened it in excel to try to identify the problem.

Looks like it's not an encoding issue then, back to the drawing board.
__________________
X-Cart version 5 (Previously 3.5-4)

Previous Versions included
BCSE Reward Points Mod
Altered Cart On Sale Mod
Wordpress Plugin

Please don't PM me for support. I help where I can on the forum and your question will more likely be answered there.

Shout me a Coffee!
Reply With Quote
Reply
   X-Cart forums > X-Cart 5 > Third Party Add-Ons for X-Cart 5


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 12:44 AM.

   

 
X-Cart forums © 2001-2020