Imports 2.0 is an administrator tool in pixi* Control Center. This tool enables you to connect to shop and synchronize item and order information between pixi* and shop. It is used to:

Import items and orders from shop to pixi*
Export stock, item and order details from pixi* to shop

Imports 2.0 tool enables pixi*Administrator to set up, monitor and control the import and export process, and fix errors found during the XML parsing and constraints checking for an item or order. In addition, email notifications can be configured to alert the pixi* Administrator in case of problems with the Imports 2.0 functionality.

Operation of the Imports 2.0 tool is regulated with the channel options and database settings. 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. In this case an auto email is generated and sent. 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 inserted or updated in pixi*.

Imports 2.0 is set up to run automatically in regular intervals. The import/export processes are started by a server job, which is scheduled to run every 5 minutes and includes the following steps:

Item import
Order import
Item export
Order export

The server job executes these steps one by one. If the process for a certain step is still running from the previous start, the job does not start it again until it is finished. The time interval between executions of processes for item/order export can be configured with database settings. The minimum value is 1 minute, the maximum is 60 minutes and 5 minutes is the default value that will automatically be set in case the entered value is outside 1-60 min. or not a valid number. The processes run each in their own server job and time interval can be configured for each job separately. Additionally a separate job was created for the XML parsing for item and order import.

Instructions how to setup Imports 2.0 you can find here: Imports 2.0 - Setup

Important information for troubleshooting you can find here: Imports 2.0 - Troubleshooting

Run Imports 2.0

To access the Imports 2.0 tool, open the pixi* Control Center and click the Import and Export tab.

The Overview panel enables you to monitor the ongoing import/export process, check if import and export services are running, search for imported and exported items and orders, and fix potential errors in the XML files. The Overview panel displays information about current status of transactions that were already performed or are waiting to be processed for every active channel:

Number of XML files in queue for (item) export to shop
Last item XML export
Items not imported because of errors
XML files with errors received today (for items)
Last item XML import
Last successful item import
Number of XML files in queue for (order) export to shop
Last order XML export
Orders not imported because of errors
XML files for with errors received today (for orders)
Last order XML import
Last successful order import

Error status indicates that the transaction was not successful. Warning status is displayed if time since last transaction (specified with the database settings) is exceeded, which indicates potential problems with the import/export processes.

Item/Order import: this process is started when pixi*sends an XML request, inquiring about new or changed items in the shop. The shop answers with an XML response. In case of changes, the XML file contains items that were changed since the last inquiry. The XML file status shows the current state of the process (importing, parsing, constraints checking...). In case of no errors items are imported and updated in pixi*. In case of errors in the XML file the items are not imported and an auto email notification is generated and sent. The errors in the XML files can be fixed manually and the file can be reimported. For more information refer to chapter Troubleshooting Imports 2.0.

Note that for URL connection type importing bundle items is also supported.

Item export: this process synchronizes stock data between pixi* and the shop. When stock or minimal stock is changed in pixi*, an XML file (with changed items) is generated and sent to the shop. Shop answers with an XML response, and in case of no errors, the stock is updated in the shop. The errors in the XML files can be fixed manually.

Note that the XML file can be generated for each item separately or can be generated in batch (for example, 100 or 1000 ITEMS). This can be configured with database settings.

Pixi* administrator can also start item export to shop immediately in Item Info and search for the transaction in the Imports 2.0 tool.

Order export: order is exported to shop if order status is changed to HAL, ANG, AUS, RET, NLB, STO together with Tracking ID and Item Note (if they exist). An XML file is generated for each orderline (ordered item) separately.

Imports 2.0 is set up to run automatically in regular intervals. This depends on the connection type for the channel. The time interval for item/order export can be configured with database settings. In addition, you can also run the import or export process manually.

Search for Imported/Exported Items and Orders

Open pixi* Control Center and click the Import and Export tab.
In the Overview tree structure, click the required folder.
Specify one or more search parameters and click Search. Note that search parameters are not required. In that case the XML files or Items records are sorted by creation date in search results.
Double-click the record in the table.

Notes:
The search works for the last 14 days only.
Click Clear to delete selected search parameters.
Once a day, an email report “Import Status” is sent to pixi* administrator with the item/order import statistics.
Once a day, an email report “Export Status” is sent to pixi* administrator with the item/order export statistics.

Import All Items from Shop

Warning: Importing all items from shop can cause pixi* server performance problems. Don't use this function unless it is necessary and make sure that the process is finished before you start it again.

Open pixi* Control Center and click the Import and Export tab.
Click Tools in the navigation tree.
Select the channels in the list in the Shop Import service.
Click Import.

All items from the selected channels are imported to pixi*.

Export All Items to Shop

Warning: Exporting all items to shop can cause pixi* server performance problems. Don't use this tool unless it is necessary and make sure that the process is finished before you start it again.

Open pixi* Control Center and click the Import and Export tab.
Click Tools in the navigation tree.
Select Items and/or Bundles in the Shop Connection service.
Click Export.

Selected items and/or bundles are exported to all enabled channels according to the item export options for each channel.

Notes:
- Stock quantity, minimum stock quantity, delivery date and barcode are exported for items.
- Only available stock is exported for bundles.
- The option “Include inactive items with stock 0” is available. By default, the checkbox is OFF, so only active items and inactive items with stock are included in Full stock export. When you change it to ON, then all items are exported.
- The option "Item Export - Status or Reorder Level on Location" is available. The option is empty by default, which means that only the status of the item is exported. The value "1" is exported in case the item is available and "-99" in case the item is unavailable. Enter a location ID to export the reorder level of a specific location (e.g. "001").

Export Single Item to Shop

Information for single item can be exported in the Item Info module.

Search for an item in one of the pixi* applications.
Open Item Info for the selected item.
In the General tab, click Export Item to Shop.

Note: To check if an item export was successfully started and processed, search for the exported item in the Control Center > Import and Export tab > Item Export Search.

Stock Export

When an order is imported to pixi*, the stock for ordered items is automatically exported to shop. Exported stock value is calculated according to database settings:

Export Physical Stock for items (not bundles)	Enable Reservations	Export available stock- reservations are enabled	Exported:
ON	OFF or ON	-	Physical stock
OFF	OFF	-	Available stock
OFF	ON	ON	Available stock
OFF	ON	OFF	Available stock (res)

In combinations when database setting Export Physical Stock for items (not bundles) is enabled, the physical stock is always exported.
In combinations when database setting Enable Reservations, available stock is exported.
With enabled reservations the following setting controls exported bundle stock in folder Imports 2.0 > Export > Bundle stock export and display