User Tools

Site Tools


ecommerce_export_problems

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
ecommerce_export_problems [2014/01/13 20:41 (10 years ago)] – [2. search for the part number inside the inventory table of the site's database using phpMyAdmin] rcunananecommerce_export_problems [2022/08/29 10:23 (19 months ago)] (current) asegert_windwardsoftware.com
Line 1: Line 1:
 +<note warning>This is outdated, please see the updated [[ecommerce_integrations:overview|E-Commerce Documentation]] for current E-Commerce information</note>
 +
 ====== Problems with E-Commerce Export ====== ====== 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+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(open part in system five and open web tab). Also, get the credentials from the customer's real windward information. 
  
 ==== 1. direct the URL to the exact page of the item ==== ==== 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 ==== ==== 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 inside the inventory table, check to see if there it is a matrix child item by looking if the parent column is not NULL ==== 
  
-By design, matrix child items are not listed when their categories are clicked or when they are searched with default search strings BUT they can still be searched if you include &include_kit_items=true inside the search string (adding <input type="hidden" name="include_kit_items" value="true"> in the search section of default.html)+if the item will not display when clicking its category, try to do a search for it using either part number or description
  
-The only way I know to work around this(at least with my testing) is to convert the item from System Five itself into regular item by going to the parent item, removing kit information from the kits tab, and toggling the parent item to not export to ecommerce. The next inventory exports should treat the child items as regular items which can be searched without extra search strings and can be listed down by default.+==== 3. If the item is Matrix Child Item, search for or directly go to the page of the Parent Matrix Item ====
  
-==== 4. If the parent column in the inventory table is NULL, check if the partno is in the categorymap table ====+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.
  
-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 ======+===== CHECKING SYSTEM FIVE SETTINGS ====== 
 +==== If the items still do not show up on the site, then there is a possibility the problem occurs during the export process from system five =====
  
 ==== 1. check to see if there is an inventory.zip inside their ftp temp folder ==== ==== 1. check to see if there is an inventory.zip inside their ftp temp folder ====
Line 40: Line 29:
 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 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.+{{:ftp.jpg?800}}
  
-==== 2. If there is no inventory.zip file inside temp folder at all, it means the FTP settings on their XML Central is wrong ====+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. You will have to change the credentials in the ecommerce tab again to what is indicated in their real windward customer record. 
 +==== 2. If there is no inventory.zip file inside the temp folder or a recently created partimport_* folder, 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.+You can test this by using FileZilla to move a dummy inventory.zip 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. or the service development team.
  
  
ecommerce_export_problems.1389674470.txt.gz · Last modified: 2014/01/13 20:41 (10 years ago) by rcunanan