This article should help you finding and fixing errors in item or order import and export.

Check if imports are working properly

Follow these steps to check if imports for enabled channels are working properly:

1. Open Control Center and click on Import and Export tab.

2. Click on Overview in the navigation tree.

3. Check the information about the processes in the Overview table. Pay special attention to warnings and errors.

4. Check that all services are running in the Service Status panel.

Note: Warning is displayed if there was no activity in a period specified in the setting for that process.
Error is displayed if transactions with errors exit for that process.

Back to top

Troubleshooting

Each incoming or outgoing XML file is parsed and checked against constraints to prevent importing items or orders with missing, wrong or incompatible data to pixi. If an XML file contains errors, this file is saved in the intermediate table and is not imported.

The following statuses are used for the XML files:

• In the Overview panel:

  • Error: transaction was not successful.

  • Warning: maximum time interval between two import/export processes is exceeded (time interval is configured with database settings)

• In the Item/Order Import Search window where import type is Item and XML files:

  • XML ERROR: received XML file is not valid.

  • SHOP ERROR: no response from the shop.

  • CONSTRAINTS CHECK: constraints check is performed.

  • XML IMPORTED: XML file import is done.

  • XML HAS NO ITEMS: XML file without items; there are no changes since the last XML file was received.

  • XML PARSED: XML file was parsed and checked.

  • XML PROCESSED (all imported or updated): the XML file was successfully processed and updated in pixi.

• In the Import Search window where import type is Item and Imported Items:

  • OK: item was imported and updated in pixi.

• In the Import Search window where import type is Item/Order and Records:

  • ERROR: item/order record with error (conditions for constraints were not fulfilled).

• In the Export Search window where export type is Item/Order:

  • ERROR: no response from the shop.

  • OK: item/order was successfully processed and exported to the shop.

  • READY TO EXPORT: XML file is waiting to be exported (processed).

The errors in the XML files can be fixed manually and files can be reimported to pixi. When XML files are successfully imported, the received data is updated in pixi.

Note: The XML contents displayed in the pixi Control Center contain neither CDATA tags nor the first line <?xml incl. Encoding as described in this article, for example: Order import

In case of errors with the import/export processes an auto email is generated and sent. Auto email notifications are sent in the following cases:

• Successful import/export

• Errors while importing/exporting

• Exceeded period between successful imports/exports (the period can be configured with a database setting)

• If the connection to the shop is lost “Channels Error”.

• In case of critical exception “Critical Imports Error”.

• In case of imported order with shop note “Order with Shop Note”.

Note: Auto emails can be enabled or disabled with database settings in pixi Control Center.

Back to top

Fix Errors in "Parsed and Checked" Window

When an error is found during the XML parsing and constraints checking for an item or order, the pixi administrator can fix the XML file.

1. Stop the Item Import or Order Import service.

2. Click Item Import or Order Import in the navigation tree.

3. Specify the search criteria:

   • Status: Error

   • Record Type: Parsed & Checked

4. Click Search to find the items/orders with errors.

5. Double-click the item/order to open the Import Details window.

6. Check the errors listed in the Errors panel and fix all fields which are highlighted with red in the different tabs.

   1. Data entered into a field is saved and checked when you move to another field.

   2. If an error is successfully fixed it will disappear from the Errors panel.

   3. Information about imported tags in the Tag tab is read-only

7. Click Save & Import. If all errors are fixed the item/order will be immediately imported to pixi.
   Note: If the change is not accepted, open the XML from the "XML files" area, carry out the changes again and save them.

8. Restart the Item Import or Order Import service.

Note: If the same type of errors are recurring on regular basis, we recommend to contact support for shop or pixi to fix the cause of the error on the shop side and prevent further errors on imported items.

Back to top

Verify URL Channel Connection Settings

In case of different import/export problems, for example:

• XML files are not received from shop,

• the same XML file is imported several times,

• XML file status in something other than XML PROCESSED or XML HAS NO ITEMS,

• Item or order is not exported to shop

• exported XML file has status NO VALID RESPONSE,

you can check the URL channel connection settings.

Check channel connection:

1. Open pixi Control Center and click the Import and Export tab.

2. Click Options and then Edit Channel.

3. Select a channel and click Check Connection:

   • If session ID is returned, contact pixi Support.

   • If session ID is not returned, check URL channel connection settings.

   
   

Check channel settings (URL, username, password…) and syntax:

• If settings and syntax are wrong, fix them (enter correct URL, username, password…).

• If settings and syntax are ok, contact pixi Support.

Check URL channel connection settings:

Open an internet browser and enter the internet address of URL call:

• Shop URL

• Authorization URL

• Confirm Catalog URL

• Confirm Order URL

• Export Catalog URL

• Export Order URL

• Import Stock URL

• Send Order Change URL
  

Note: Confirm Catalog URL call (for item import) and Confirm Order URL call (for order import) is a confirmation sent back to the shop that the XML file with items or orders was successfully imported in pixi.

In case the response to any of the URL calls is an error message or a blank page, contact pixi Support.

Back to top

Reprocess XML Files

If the final status of the XML file is different than XML PROCESSED or XML HAS NO ITEMS, something went wrong during the import process and an item or order was not imported to pixi. In this case you can reprocess the XML file.

1. Open pixi Control Center and click the Import and Export tab.

2. In the Overview tree structure click the required folder.

3. Specify one or more search parameters for the required XML file and click Search.

4. Click Reprocess XML.
   

The XML file is reprocessed (parsed, constraints checked and applied to main tables). In case this did not solve the issue, contact pixi Support.

Back to top

Delete XML Files

When errors, found in XML files during the XML parsing and constraints checking for an item or order, are fixed in shop and fixed XML files are reimported, the original XML containing errors can prevent importing the fixed XML file. In that case you can delete the original XML file.

In the Item Import or Order Import select the files you want to delete and click Delete XML. XMLs that have the following status can be deleted:

• XER (XML-Error)

• ERR (Error)

• SRR (Shop-Error)
  

Important: To delete the XML files you need the user permission, set in Group Control Center > "Delete Error XMLs > User is allowed to delete imported XML files with status “Error” (Imports 2.0)". By default this user permission is disabled for all user roles.

Functionality of deleting XML Files is available from pixi LOU Update 7 on.

Back to top

Process information in the Overview table

Date of the last activity, operation type, messages for operation types and status information are displayed for each enabled channel.

Item Import process overview

Order Import process overview

Item Export process overview

Order Export process overview

Back to top