User Tools

Site Tools


ecommerce_export_problems

This is an old revision of the document!


Problems with E-Commerce Export

Workflow: ask the customer for the system five part number, windward unique number, and description of the part in question and make sure it was checked for export to e-commerce on system five

1. direct the URL to the exact page of the item

example: http://website.com/wecs.php?store=&action=display&target=xxxxx where xxxxx is the part number if the e-commerce configuration is set to use part numbers or unique number if it is set to unique number (General option number 12 in admin panel)

2. search for the item description or part number on the e-commerce website

By default, we cannot search for a part number on wecs due to a bug, we have to add &advancedsearch_word_modifier=phrase in the search string

example: http:website.com/wecs.php?store=&action=searchadvanced&advancedsearch_include_description=1&advancedsearch_word_modifier=phrase&advancedsearch_words=xxxx where xxxx is the part number

This can be done by adding <input type=“hidden” name=“advancedsearch_word_modifier” value=“phrase”> to the search section of the default.html

3. If the item is a Matrix Child Item, search for or directly go to the page of the Parent Matrix Item

By default, Child Matrix items are not searchable. If you search for the parent matrix item and see if the options for the child item are available. example, PARENTITEMPART123456 color=red size=small.

4. If the parent column in the inventory table is NULL, check if the partno is in the categorymap table

The categorymap table takes care of which category an item is attached to

4. If not in the categorymap table, run the category mapping utility in the admin panel

This step will write into the database which category number an item should belong to in the categorymap table

IF THE ITEM IS NOT IN THE DATABASE AT ALL

1. check to see if there is an inventory.zip inside their ftp temp folder

This will mean there was a last attempted update but it was not successful. successful exports will move the inventory.zip inside a part_import folder

The most likely reason that an inventory.zip is still in the temp folder is that the credentials for the e-commerce tab in the XML Central export settings is wrong.

2. If there is no inventory.zip file inside temp folder at all, it means the FTP settings on their XML Central is wrong

You can test this by using FileZilla to move a small file into the temp folder using the credentials which should be saved inside the customer's comments tab. If you can log in to the FTP folder but you cant move files, then it is likely an FTP issue which you can address to I.T.

ecommerce_export_problems.1389674650.txt.gz · Last modified: 2014/01/13 20:44 (10 years ago) by rcunanan