The following dialog is displayed to either show all the products or those available for selection.



You can find a specific product by typing in the Find text area and clicking on the Find button. This will look in all fields for the products. You can also filter products on all of the main product details. This can be useful if your products are all listed by Suppler, Bin.Location or another common field (to your orders).

Products can be created in a number of ways:

1 New button. You are then shown the Product Details dialog.
2 Copy button. This copies the selected product and you shown the Product Details dialog.
3 Automatically create products from imported orders. This is defined when you import products.
4 Import products from a CSV file. You can update existing products with only the few required fields (e.g. to update the EANs or ASINS in all of your products).
5 Use the Products->Import->From Selected Orders menu option. If you already have products in your system you can create the products from the selected orders.

You can use the Export button to take the products out of One Stop Order Processing into a CSV file. You can then manipulate your products in Excel before importing back in again (or importing to a 3rd party system).

You can also use this facility to import product details from other systems. The format of the CSV file is:

Import file format
The import file is a standard CSV (Comma Separated Value) file. The first line contains the field names separated by a comma (,). Each subsequent line contains values for those fields, each value being separated by a comma (,). Microsoft Excel can export information as a CSV file. You can create a template (example CSV file) by using the Export button and exporting an existing product.

The product import file can contain any of the fields described below, in any order. If you do not know any of the information for a field don't include the field in the file to import. This is described below.

You can use this approach to import stock levels based upon the item's SKU, and only include 2 fields in your product import file, SKU and CurrentStock).

Minimum requirements for an import file
You must have at least 1 of the red fields in your import file to create a valid One Stop Order Processing product.

Advanced Import

To import information into existing products you only need to include the SKU, EAN, Title or Description and the required information (e.g. CurrentStock). You must use the SKU if you are importing a field that is used for a platoform. These fields are:

Title, Description, Price, ShipCost, VATRate, Currency, SellingPlatform, Brand, Manufacturer, ProductType, Condition, Image1, Image2, Image3, Image4, Image5, SearchTerms, WebPage, Category, SellingFormat, Duration, Availability, OriginalPrice, ShippingDest, ASIN, CustVal1, CustVal2, CustVal3, CustVal4, CustVal5, CustVal6, CustVal7, CustVal8, CustVal9, CustVal10, CustVal11, CustVal12, CustVal13, CustVal14, CustVal15, CustVal16, CustVal17, CustVal18, CustVal19, CustVal20, SiteStock

that An example of a CSV is shown below. This can be edited in Microsoft Excel and exported as a CSV file.

SKU,CurrentStock
IL513,100
IL611,10
AB551,12