Products
For products to be sold on Debenhams they must be a debenhams type. Only composite items are eligible.
The product name must contain a unique name plus a short description. The unique name must title case and be surrounded by apostrophes. If the name is at the start it should have two apostrophes. For example: ''Summer Fun Times' red wine case. The description should contain the word 'wine' for search optimisation and should be lower case.
The packaging description is only required for gift orders that are shipped in something other than a standard box. The weight should be in the format 7.2kg. The main dimensions should be in the format 252 x 168 x 335mm. The volume should be in millilitres in the format 4500.
The allergens attribute it optional. If no value is specified the default of "Contains sulphites" will be used.
Product files can be generated in Telesales by selecting Corporate > Debenhams from the menu. A CSV file should be uploaded with a list of product codes (one per line). Depending on the selected option a different file will be generated. In most cases the file will also be uploaded to the Debenhams FTP server. This is not the case for the load file which should be manually emailed.
| Option | File | Additional Details | FTP Upload Directory |
|---|---|---|---|
| Add product | Product XML | Each product will have the add ('A') action | /PRODINFOXML/INBOUND |
| Change product | Product XML | Each product will have the change ('C') action | /PRODINFOXML/INBOUND |
| Delete product | Product XML | Each product will have the delete ('D') action | /PRODINFOXML/INBOUND |
| Images | Zip/Png | /PRODINFOXML/INBOUND | |
| Add/Amend inventory | Inventory | The record type for each product will be amend (52) | /PRODINFO |
| Delete inventory | Inventory | The record type for each product will be delete (50) | /PRODINFO |
| Update PLU | PLU | The file type will be update (0) | / |
| Refresh PLU | PLU | The file type will be refresh (1) | / |
| Load File | Load | none |
PLU
In the PLU the was price will be used as the permanent price unless the was price is not present, in which case the current price will be used. The current product price will be used as the promotional price. If there is no promotion then the was price and current price should be equal, this will set the promotion price to 0 in the PLU file, indicating that there is no current promotion.
Basically, if you're only going to configure the current price and leave the was price blank that's fine. It's also valid to set the was price to the same value as the current price. However, if you only set up the current price and you later want to configure a promotion, you'll have to change the was price to be the current price value and set the current price as the promotional price.
Inventory
The inventory is generated nightly. To be included in the inventory the product must be a debenhams type, it must be active, the state must be ready to sell, and the product must be sold on telesales. If the product availability state is not available the stock level will be reported as 0.
Orders
The order file has some quirks. Although each line has it's own addresses, all addresses within the an order will be identical. Line 5 is always a duplication of the city, county and postcode. The quantity of all lines will always be 1, if multiples of the same products are bought there will be multiple lines. If address lines have more than 25 characters they will be wrapped.
Orders will be placed with the DEB order type. The Debenhams customer order number will be store in Mantiki as the purchase order number.
Options
Options changes have been implemented to include additional details in the order extract XML for Debenhams orders:
| Element | Parent | Type |
|---|---|---|
| SupplierLineTotalValue | OrderLineType | String |
| SupplierProductDepartment | OrderLineType | String |
| ProductEANBarcode | OrderLineType | String |
| SupplierOrderNumber | OrderHeaderType | String |
| SupplierStoreNumber | OrderHeaderType | String |
| SupplierReturnsBarcode | OrderHeaderType | String |
| SupplierFulfilmentRoute | OrderHeaderType | String |
These are propagated from the Debenhams order files. In addition the CCNumber element will be populated with the last four letter from the card that the order was placed with.