Introduction

JGBM can provide a Product Data Feed. The feed includes price, stock and catalogue files. The purpose of these files is to import your JGBM buy price, JGBM stock levels and product data into a back-office system or e-commerce website.

JGBM can also provide EDI integration. This allows you to send orders electronically from your back-office system, directly to JGBM. Acknowledgements, invoices and credit notes are then sent from JGBM directly to your back-office system.

If you just need a basic price list, you can download a price list from our website with your latest buy prices at any time. Simply go to https://www.jgbm.co.uk/, log in, and click on Download Price File.

NOTE: Please be aware prices are subject to change at any time, stock levels change throughout the day, and products are added and removed regularly.

Product Data Feed

What is a Product Data Feed?

A Product Data Feed (also known as a product feed or price feed) is a service for providing files. The JGBM product data feed includes price, stock, catalogue, attributes and accessories files.

These files can be imported into a back-office system or e-commerce website. Which files you require, the file format and the delivery method will depend on which back-office system or eCommerce website you use.

The default files are in CSV format and are hosted on JGBM’s FTP server.

Feeds can be customised if you have specific requirements.

Product Data Feed Details

The JGBM product data feed consists of the following files.

 

Catalogue File


Updated 07:00 Daily*

This is an all-in-one file. It contains our product data (description, weight, size etc), your buy price and JGBM stock levels all in a single file.


Most commercially available back-office systems/e-commerce websites get JGBM product data using Fusion or directly from JGBM. These systems only require your buy prices and stock from JGBM and don’t require a catalogue file.

Terms File


Updated 06:00 Daily*

This file contains your buy price. This is typically required to import your buy prices into a back-office system/e-commerce website.

Stock File


Updated Every 10 Minutes*

This file contains current stock levels. It includes stock available from our warehouse and stock available from the manufacturer.


Many back-office systems/e-commerce websites have the ability to update stock on a regular basis.

Attributes File


Updated 07:00 Daily*

The attributes file lists a product and its associated attributes. For example attributes for a shredder would include sheet capacity, bin size and security level etc.


This file is not included by default and is available on request as most systems would require development work to utilise the file.

Accessories File


Updated 07:00 Daily*

The accessories file lists a product and its associated accessories. For example, a shredder would show any shredder bags or lubricant that would work with that product.


This file is not included by default and is available on request as most systems would require development work to utilise the file.

*This is how often JGBM updates the files. How often your files are updated will depend on your back-office system/e-commerce website.

JGBM can provide the following files to the leading office products industry back-office systems and e-commerce websites.

System

Catalogue File

Stock File

Terms File

Attributes File

Accessories File

Prima

Yes (From Prima)

Yes

Yes

No

No

Oasis

Fusion

Yes (Split Stock)

Yes

Fusion

No

ECi Horizon

Fusion

Yes

Yes

Fusion

No

ECi Progress

Fusion

Yes

Yes

Fusion

No

Heart Pulse

Fusion

Yes

Yes

Fusion

No

Calidore

Fusion

Yes

Yes

Fusion

No

EvolutionX

Fusion

Yes

Yes

Fusion

No

CommerceXchange

Fusion

Yes

Yes

Fusion

No

Office Power Platform

Yes

Yes

Yes

No

No


EDI (Electronic Data Interchange)

What is EDI?

EDI (Electronic Data Interchange) is the electronic transfer of documents from one business to another. JGBM can provide electronic ordering, acknowledgements, invoices and credits via EDI.

EDI Details

EDI is currently available to the following back-office systems;

System

Order

Acknowledgement

Despatch

Invoice

Credit

Prima

Yes

Yes

No

Yes

Yes

Oasis

Yes

Yes

*

Yes

No

ECi Horizon

Yes

No

No

Yes

No

ECi Progress

Yes

Yes

No

Yes

No

Office Power Platform

Yes

Yes

Yes

Yes

Yes

*Available with Oasis Approval


Further Help

If you have any further questions, please contact it@jgbm.co.uk.

If you would like to request a Product Data Feed or EDI, please go to https://www.jgbm.co.uk/content/datafeed.html