Windows Live Product Search Contribution Support Thread

[numinix]

IMPORTANT NOTE:

Because it takes so long for Windows Live Product Search to process the list, and there are no product id's included in the XML file as WLPS doesn't support this attribute yet, if you reupload your file, the processing will start over! This is a huge setback in this marketplace and I will be writing to them immediately to resolve this issue.

[DrByte]

fastserv's note brings up a common mistake often only uncovered in non-english shops ... the language value in the query isn't sufficiently forced to proper datatype.

AND pd.language_id = ORDER BY p.products_id ASC

Note that the language_id is missing. This often occurs when the default language is being used and there hasn't been a need to explicitly set one.

It's usually best to at least use (int) before listing $_SESSION['language_id'] in the query parameters.

ie: [FONT="Courier New"](int)$_SESSION['language_id'][/FONT]

[numinix]

I'll include that in all future updates of my feeders. It's strange because that portion of the code was written by a_berezin who's primary shop language is Russian

I've just written to WLPS and requested them to add a new attribute called <OfferID>.

[aPurpleMonkey.com]

Having problems with this contribution and your Google Base one as well...same issue actually...

When I click on Step 1 it throws the popup and then immediately stops. Nothing displayed in the window...nothing saved in the feed file.

Added the changes to my php.ini and changed the script execution time in Admin.

Still nothing.

Any ideas?

Is this a hosting issue? If it is what do I need to have my host change to allow this to work?

Thanks for providing such killer add-ons.

[dssprogrammer]

I get the following error while trying to run the .sql patch, Please advise:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'true', 'false'),'), (NULL, 'Uploaded date', 'LPS_UPLOADED_DATE', '', 'Date and t' at line 1
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, 'Live FTP Username', 'LPS_USERNAME', 'ftp_username', 'Enter your LPS FTP username', @configuration_group_id, 1, NOW(), NULL, NULL), (NULL, 'Live FTP Password', 'LPS_PASSWORD', 'ftp_password', 'Enter your LPS FTP password', @configuration_group_id, 2, NOW(), NULL, NULL), (NULL, 'LPS Server', 'LPS_SERVER', 'ftp.productupload.live.com ', 'Enter Live Product Search server
default: ftp.productupload.live.com', @configuration_group_id, 3, NOW(), NULL, NULL), (NULL, 'Default Currency', 'LPS_CURRENCY', 'USD', 'Only USD currently supported', @configuration_group_id, 5, NOW(), NULL, 'zen_cfg_pull_down_currencies('), (NULL, 'Output File Name', 'LPS_OUTPUT_FILENAME', 'lps.xml', 'Set the name of your Live output file', @configuration_group_id, 19, NOW(), NULL, NULL), (NULL, 'Compress Feed File', 'LPS_COMPRESS', 'false', 'Compress Live Product Search file?', @configuration_group_id, 20, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Uploaded date', 'LPS_UPLOADED_DATE', '', 'Date and time of the last upload', @configuration_group_id, 21, NOW(), NULL, NULL), (NULL, 'Output Directory', 'LPS_DIRECTORY', 'feed/', 'Set the name of your feeds output directory', @configuration_group_id, 20, NOW(), NULL, NULL), (NULL, 'Use cPath in url', 'LPS_USE_CPATH', 'false', 'Use cPath in product info url', @configuration_group_id, 20, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Max products', 'LPS_MAX_PRODUCTS', '0', 'Default = 0 for infinite # of products', @configuration_group_id, 24, NOW(), NULL, NULL), (NULL, 'Included Categories', 'LPS_POS_CATEGORIES', '', 'Enter category names separated by commas
(i.e. computers,software,televisions)
Leave blank to allow all categories', @configuration_group_id, 30, NOW(), NULL, NULL), (NULL, 'Excluded Categories', 'LPS_NEG_CATEGORIES', '', 'Enter category names separated by commas
(i.e. computers,software,televisions)
Leave blank to deactivate', @configuration_group_id, 30, NOW(), NULL, NULL), (NULL, 'UPC', 'LPS_UPC', 'false', 'Include products UPC?', @configuration_group_id, 32, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'ISBN', 'LPS_ISBN', 'false', 'Include products ISBN?', @configuration_group_id, 32, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),');]
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.

[DrByte]

Try copy-and-paste the file contents into the SQL Patch window instead of simply browsing for the file.

[numinix]

Try copy-and-paste the file contents into the SQL Patch window instead of simply browsing for the file.

Yes, please read the included readme.txt file for instructions on how to properly install and use this script.

[dssprogrammer]

Doh, thanks numinix for reminding me what readme files are for. ;)

It took this time.

[dssprogrammer]

One more little snag.
All went well up to step 7.
"7. Go to Admin->Tools>Live Product Search Feeder and follow instructions to create, view, and upload feed file."

I don't see the Live Product Search Feeder link it the Tools list
(strange, because step 5. was OK)

Am I doing something stupid again?

[batteryman]

Hello,

I am glad to see that you made the MSN Product Live. I was manually having to modify the output of your Google Feeder to get the correct feed style for MSN.

I really appreciate it. I made a small contribution for your efforts. Its all I could afford at the the moment.

Thank you
avel