Integration item

Introduction

The item information it’s maintained in Harmoney. The idea of Harmoney is that information should only be entered and maintained in one place regardless of whether the information is used in a variety of systems. Therefore all item information is updated from Harmoney. In order to maintain the correct item information synchronized with external parties, item files are submitted once or several times per day.

Technical description

The files are pipe-seperated created from Harmoney. Empty characters at the end of a field i trimmed to compress the files. The files are uploaded via FTP-server. The frequency of the file upload is scheduled.

Item files

General information

There are a number of files containing different information. These files are

  • Item file
  • Deleted items
  • Price file
  • Deleted prices
  • Deleted prices on item variant
  • Item name file
  • Deleted item names file
  • Item description file
  • Deleted item descriptions file
  • Property file
  • Property values file
  • Item properties file
  • Deleted item properties file
  • Stock balance file
  • Stock balance for stores file
  • Stock transactions file
  • Stock item barcodes file
  • Deleted stock item barcodes file
  • Bundled item file
  • Deleted bundled item file
  • Cross sale items file
  • Deleted cross sale items file
  • Brands file
  • Item class file
  • Item group file
  • Item code file
  • Activities(Campaigns) file
  • Discount terms file
  • Discount lists file
  • Discount item detail file
  • Discount item file
  • Item calculated average purchase price file
  • Item statistical numbers file
  • Suppliers file
  • Delivery methods file
  • Item delivery methods file
  • Pick Up locations file
  • Periods file
  • Item period file

It’s up to the client to decide which files they want Pulsen to send. The client can also decide the name of the files.

The fields in the files are PIPE-separated by default. We can also send the files as XML. All date fields has the format yyyy-mm-DD.

Fok = SalesChannel. Harmoney is configured with one or more sales channels, e.g. “Web shop Sweden”, “Warehouse Oslo” etc. Each sales channel has a three letter code, this is the code that i sent in the files. An item can have a different information in each sales channel. Many of the files described on under files(link to files) might be an addition to the integration to Harmoney.

General information about the incremental(partial) files

The incremental(partial) files are exported to give an indication about items or part of items that has been removed since the last full web export. The full web export files gives a complete picture of how the database look like while the incremental(partial) files provides a snapshot. You can have the files with extension .txt or you can have the extension as Pulsen recommend .part for incremental(partial) files and .full for full files.

Structure of an item(article)

The structure of an item in Harmoney contains an item number and 0-5 attributes. An attribute can for example be a color while another attribute can be size. When Harmoney is configured, the structure of the item is set. The combination of item number and item attribute is called an item variant.

E.g. Item 123456 is sold in the color black(color-code 1234) and the size small(size-code 001). The item variant then becomes 123456-1234-001. The length of an item number and item attribute respectively is decided when Harmoney is configured. These lengths can differ per item, a zero padding will take place to the decided length. Maximum length to be used is 15 characters for the item number and 5 characters for each attribute. The attributes codes and meaning are set up in a control table in Harmoney.

Address

The files are usually tranferred via FTP.

The client provides Pulsen the address where the files should be sent. Pulsen needs

  • URL
  • User name
  • User password
  • Directory

Below are links to the documentation about Pulsen’s item integration

File Url
IntegrationArtikel.pdf(SV) IntegrationArtikel.pdf.