E-commerce Fulfillment

Create automatic data files

The automatic data file is a file containing information about the complete product range at Copaco in CSV or XML format. You can use this file to create your own price lists or to import our prices in your ERP or web applications. We update this data file every night and allow access via the Copaco FTP server.

Below you will see which fields contain the automatic data file:

Request an automatic data file

As Copaco’s customer you can go to the request form using the button below. We will then activate your automatic data file as quickly as possible. Not yet a customer at Copaco? Then click here.

Request automatic datafile

Generate your own data files

You can use the Copaco webshop to generate your own data file. We can send this data file to you whenever it suits you. In your personal zone you can confirm exactly which brands must be included in the file and in what format (.xml of .csv) you wish to receive this article information. You will then receive your data file by e-mail within a matter of minutes.

Your generated file contains the following information:

• Article
• Manufacturer's code
• Brand
• Description
• Price
• Price including fees
• Stock
• Product format
• UNSPSC_code
• EAN_code
• Status
• Disposal fee
• private copying levy
• Stibat

You can create your own virtual warehouse in combination with the Real-Time Price & Availability check.

Generate your own data files

Open IceCat

Using content provider ICEcat.biz you can gain access to the free supply of product data sheets known as Open-ICEcat. You can use this free content to add rich content easily to an article file. If you would like more information, please send an e-mail to info@icecat.biz or look at www.icecat.biz.

How do I open the file?

Due to the size of the file, price lists are compressed into a ‘.zip’ file. You can decompress this file using the free program 7-Zip.

Why has all information opened in a single column?

In the .csv file you receive, the various columns in the price list are separated by a comma. If your country settings are on ‘English’ you should experience no problems in opening the file in Excel after unzipping.

Are your country settings on ‘Dutch’? This causes the comma to be viewed as a decimal point rather than as a divider which means that all information will end up in a single column in Excel.

By following the steps below you will easily be able to open the .csv file over a number of columns:

• Open the .csv file in Excel;
• Then select column A;
• In the ‘Data’ menu go to ‘Text to columns’;
• In the Wizard Text to columns in step 1 choose file type ‘Separated’;
• Then click on the button ‘Next’;
• In step 2 select separation signs ‘Tab’ and ‘Comma’;
• Then click on the button ‘Next’;
• In step 3 under Details Per Column choose ‘Text’;
• Then click on the button ‘Finish’;
• Your price list will now open across a number of columns.
li>

Why can I only request one single price list?

Does the ‘send’ button disappear after sending, but you still wish to request another price list? Then click once more on the option My price lists in the left hand menu of the webshop to request a new price list.

I wish to automatically download the complete price list

The manual download in the webshop does not allow the complete price list to be downloaded automatically. To do this you can use our data link free of charge. Using the data-link option you can update your webshop using an automated price list download. For more info see 'create automatic data files'.

XML coupling

Using the XML coupling you can connect your purchasing or ERP system to our SAP ERP system. All purchasing transactions and related messages, such as e.g. order confirmations, will be exchanged electronically. This puts an end to the need to enter your purchase orders twice, once in your purchasing system and again in our webshop. Messages are exchanged more quickly and the risk of manual errors is reduced.

System integration

There are various ways to connect your system to our SAP ERP system. You can set up the connection yourself using the DTDs that we provide for coupling via XML (eXtensible Markup Language). The e-business team at Copaco will help you to do this. In order to set up specific ERP coupling you can use our selected system integration partners.

Manual

You can download the XML manual.

Download Manual

Request Copaco XML connection

As a Copaco customer you can go to the request form via the button below. We will activate your XML connection as soon as possible. Not yet a Copaco customer? Then click here.

Request an XML connection

Connect Copaco via Onetrail

Onetrail facilitates the electronic message traffic between the order processing systems at manufacturers, distributors and resellers.

Integrated Onetrail

Most distributors have integrated their internal order processing systems with Onetrail. For those resellers that are connected to Onetrail it has become possible to receive article and price information and process orders on an entirely automated basis.

These are the advantages of a Onetrail connection:

• Standardised and up-to-date article file;
• “real-time” price and availability check;
• “real-time” order processing;
• “real-time” information about changes in the order process;
• No longer necessary to retype;
• Saving precious time;
• Saving 35% on your order completion;
• Avoiding error and subsequent damage claims;
• Increased customer satisfaction;
• Better view and control over the order process.

By shortening the ‘order-to-cash’ process, you gain time to focus on important matters, such as sales and purchasing. This eventually leads to increased turnover and better margins.

Processes supported by Onetrail

Onetrail for ICT currently consists of 2 modules:

• Purchasing
• Sales

The purchasing module

The purchasing module from Onetrail looks after the unequivocal electronic transfer of the following information to Copaco:

• All your suppliers with a single article/price file;
• Orders from your own (ERP) system;
• Order status reports from Copaco;
• Messages originating at Copaco;
• Serial number registration.

The sales module

From the moment you wish to integrate with your client, the Onetrail sales module is a valuable tool in achieving a successful connection. Using Onetrail you can provide your customers, either directly or via a webshop, with up-to-date information on products, prices and orders:

• Rich content directly from the suppliers;
• Provision of a specific article/price file;
• Real-time availability at suppliers in your own format;
• Processing and confirmation of sales orders (also via e-mail);
• Sending a sales order status (also via e-mail).

Connection to Onetrail

Once you have decided to connect to Onetrail, Onetrail will set up an action plan. This includes the determination of aspects such as your order management environment. For standard environments such as Exact, Navision, BaaN or SAP, Onetrail has ready-made connections that are easily implemented. Do you already have a connector, such as Biztalk or EDI? Then Onetrail will immediately use this for connection. Onetrail can temporarily send orders by e-mail or fax should you have partners that are not yet connected.

Price structure

Onetrail charges a one-off set-up fee and a monthly operation fee related to the number of connected trading partners.

More information

For further information, please send an e-mail to our E-Business department.

Webshop partners

Are you looking for a complete webshop, connected to the Copaco range? Copaco works with a number of other parties to offer a personalised webshop, saving you the need to invest lots of time and money in developing and maintaining one.

Our current partners:

Support in webshop implementation

Are you looking for a complete webshop, connected to the Copaco range? Copaco works with a number of other parties to offer a personalised webshop, saving you the need to invest lots of time and money in developing and maintaining one.

Our current partners: