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.

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). If you have a delivery of stock and simply want to add the current stock to the existing stock levels put a + before the number of items entered in the CurrentStock field and this amount will be added to the current stock.

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.

Update Stock details in bulk
You can update the stock details for all the ticked products by clicking on the the Update Stock button. This shows the Update Existing Stock details dialog.

Update VAT
You can update the VAT information for all the ticked products by clicking on the Update VAT button. This shows the Update Products VAT Details dialog.

Add Stock
If you want to update the stock levels of products click on the Add Stock button. You need to enter either the SKU or EAN of a product. This shows the Add Stock dialog.

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 platform. 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

Adding new stock
If you have had a delivery of existing products and you simply want to add to the new to the system you can do this. When importing if you put a + before the amount this increase the current stock level by the amount given. For example, if the current stock level is 10 and you import a value of +3 the stock will now be 13. You can also use a - to decrement stock aswell. For example, if you sold stock outside of One Stop Order Processing and want to update the stock levels.

Changing the Product fields shown

There is a file in the One Stop Order Processing directory called IL_1StopOrderProductFields.ini. This contains a list of all the product fields that can be displayed in the Product Manager. Any of the 74 fields can be displayed or filtered on and can be sorted by. The fields can be shown in any order.

There is another file called IL_1StopOrderProductUsrFields.ini. This contains the fields to display. This file contains headings titled [Fieldn], where n is the field to display at position n (e.g. [Field1] will define the first field to display. Under each [Fieldn] section is a line ID=n. Where n is the field to show at this position. The number, n, is the value taken from the product field definition file (IL_1StopOrderProductFields.ini). The value n to use is the number of the field defined in the definition file (by its heading, [Fieldn]).

For example, to include the Bin Location, decide where it should appear, for example, position 5 and then find its field number in the definitions file. Then add this ID to the view file.
i.e. The definition of the Bin Location is defined as the following, in the definitions file:

[Field13]
Name=Bin/Location
SortType=1
Width=100
FieldSQL=sBinLocation

to add this to position 5 on the screen define the following in the view file:

[Field5]
ID=13

NOTE: Your view file must start with [Field1] up to the maximum number of fields that you want to display. You must not leave any gaps in your numbering. For example, defining [Field1], Field[2], Field[4] will only load in the first 2 fields.