Definition
| Canonical Type |
Product |
Objects Name |
Product |
| Description |
Optilog Product |
| Capabilities |
Allow Push Created
|
Allow Push Updated
|
Allow Push Deleted
|
Default Configuration
Default Sync options when you first connect this server.
| Imports |
Pull Created
|
Pull Update
|
Pull Deleted
|
| Exports |
Push Created
|
Push Updated
|
Push Deleted
|
Available Fields
| Name |
Identifier |
Flags |
Data Format |
Field Description |
| Reference |
sku |
|
VARCHAR
|
Reference |
| Product Name with Options |
Libelle |
|
VARCHAR
|
Product Name with Options |
| Product Name with Options |
Description |
|
VARCHAR
|
Product Name with Options |
| Manufacturer Part Number |
IdFournisseur |
|
VARCHAR
|
Manufacturer Part Number |
| Etat de l’article |
IsActif |
|
BOOL
|
Etat de l’article |
| Poids d’une unité |
Poids |
|
DOUBLE
|
Poids d’une unité en grammes (Kg >> g) |
| Hauteur |
Hauteur |
|
DOUBLE
|
Hauteur en mm (M >> mm) |
| Longueur |
Longueur |
|
DOUBLE
|
Longueur en mm (M >> mm) |
| Largeur |
Largeur |
|
DOUBLE
|
Largeur en mm (M >> mm) |
| EAN Code |
EAN |
|
INT
|
Code EAN du produit unitaire |
| Prix de vente |
PV |
|
PRICE
|
Prix de vente |
| Prix d’achat |
PA |
|
PRICE
|
Prix d’achat |
| Stock Disponible |
Stk_Dispo |
|
INT
|
Stocks Available for Orders |
| Stock Physique |
Stk_Physique |
|
INT
|
Current Total Inventory Level |
| Stock Commande |
Stk_Commande |
|
INT
|
Reserved for Waiting Orders |
| This product is out of stock |
outofstock |
|
BOOL
|
This product is out of stock |
| Stock |
Stock |
|
VARCHAR
|
Nom du stock de l’article |
| Gamme |
Gamme |
|
VARCHAR
|
Nom de la Gamme de l’article (Interne) |
| Images |
image@images |
|
>
IMG
|
Images |
| Visible |
visible@images |
|
>
BOOL
|
Visible |
Definition
| Canonical Type |
Order |
Objects Name |
Customer Order |
| Description |
Optilog Order Object |
| Capabilities |
Allow Push Created
|
Allow Push Updated
|
Allow Push Deleted
|
Default Configuration
Default Sync options when you first connect this server.
| Imports |
Pull Created
|
Pull Update
|
Pull Deleted
|
| Exports |
Push Created
|
Push Updated
|
Push Deleted
|
Available Fields
| Name |
Identifier |
Flags |
Data Format |
Field Description |
| Date Created |
createdAt |
|
DATETIME
|
Order Creation Date: Only used to Filter Orders for Optilog |
| Internal ID |
IntID |
|
VARCHAR
|
Internal ID |
| Reference |
DestID |
|
VARCHAR
|
Reference |
| Commentaire |
Commentaire |
|
VARCHAR
|
Commentaire |
| ID Operation |
Operation |
|
VARCHAR
|
ID Operation |
| Order Origin |
Origin |
|
VARCHAR
|
Order Source Website. Used to filter Orders |
| Delivery Date |
DIL |
|
DATE
|
Delivery Date |
| Code Transporteur |
Transporteur |
|
VARCHAR
|
Les associations entre codes Code Optilog et Codes Transporteur Splash sont disponible dans la configuration du Connecteur. |
| Nom Transporteur |
TransportID |
|
VARCHAR
|
Nom du Transporteur pour cette commande |
| Tracking Number |
Bordereau |
|
VARCHAR
|
Tracking Number |
| Tracking Url |
URL |
|
URL
|
Tracking Url |
| Total (Tax incl.) |
total |
|
DOUBLE
|
Total (Tax incl.) |
| Nom du destinataire |
Nom |
|
VARCHAR
|
Nom du destinataire. Ex: Jean Dupont |
| Contact de livraison |
Contact |
|
VARCHAR
|
Contact de livraison / Nom de l'entreprise. Si non fourni, « Nom » sera repris. |
| Livraison |
Adresse1 |
|
VARCHAR
|
Livraison |
| Livraison (2) |
Adresse2 |
|
VARCHAR
|
Livraison (2) |
| Livraison (3) |
Adresse3 |
|
VARCHAR
|
Livraison (3) |
| Zip/Postal Code |
CodePostal |
|
VARCHAR
|
Zip/Postal Code |
| City |
Ville |
|
VARCHAR
|
City |
| Code ISO du Pays |
Pays |
|
ISO COUNTRY
|
Code ISO du Pays |
| Code du point relais |
CodePR |
|
VARCHAR
|
Code du point relais |
| Téléphone du contact |
Telephone |
|
PHONE
|
Téléphone du contact |
| Mobile du contact |
Mobile |
|
PHONE
|
Mobile du contact |
| Email du contact |
Email |
|
EMAIL
|
Email du contact |
| Line ID |
IDunique@lines |
|
>
VARCHAR
|
Line ID |
| Product ID |
ID@lines |
|
>
Product
|
Product ID |
| Product SKU/EAN13 |
SKU@lines |
|
>
VARCHAR
|
Product SKU/EAN13 |
| Quantity |
Quantite@lines |
|
>
INT
|
Quantity |
| Shipped Qty |
Servie@lines |
|
>
INT
|
Shipped Qty |
| Info 1 (EAN) |
Info1@lines |
|
>
VARCHAR
|
Info 1 (EAN) |
| Info 2 (Code) |
Info2@lines |
|
>
VARCHAR
|
Info 2 (Code) |
| Info 3 (Label) |
Info3@lines |
|
>
VARCHAR
|
Info 3 (Label) |
| Info 4 |
Info4@lines |
|
>
VARCHAR
|
Info 4 |
| Order status |
Statut |
|
VARCHAR
|
Status of the order |
| Order status Raw |
StatutRaw |
|
VARCHAR
|
Raw Optilog Status of the order |
| Is Valid |
Mode |
|
BOOL
|
Is Valid |
| Is To Ship |
isToShip |
|
BOOL
|
Is To Ship |
| Is Canceled |
isCanceled |
|
BOOL
|
Is Canceled |
| Is To Delete |
isToDelete |
|
BOOL
|
Is To Delete |
| Facture Client [PDF] |
Facture |
|
|
Facture Client [PDF] |
| Bon de Livraison [PDF] |
BonLivraison |
|
|
Bon de Livraison [PDF] |
| Ligne 1 de commentaire |
Libelle1 |
|
VARCHAR
|
Ligne 1 de commentaire |
| Ligne 2 de commentaire |
Libelle2 |
|
VARCHAR
|
Ligne 2 de commentaire |
| Ligne 3 de commentaire |
Libelle3 |
|
VARCHAR
|
Ligne 3 de commentaire |
| Ligne 4 de commentaire |
Libelle4 |
|
VARCHAR
|
Ligne 4 de commentaire |
| Ligne 5 de commentaire |
Libelle5 |
|
VARCHAR
|
Ligne 5 de commentaire |
| Product SKU |
ID@shipped |
|
>
VARCHAR
|
Product SKU |
| Ordered Qty |
Quantite@shipped |
|
>
INT
|
Ordered Qty |
| Shipped Qty |
Servie@shipped |
|
>
INT
|
Shipped Qty |
| Identifier |
id@parcels |
|
>
VARCHAR
|
Identifier |
| Status |
IdStatut@parcels |
|
>
VARCHAR
|
Status |
| Tracking Number |
Bordereau@parcels |
|
>
VARCHAR
|
Tracking Number |
| Tracking Url |
URL@parcels |
|
>
URL
|
Tracking Url |
| Contents IDs |
IDunique@parcels |
|
>
|
Contents IDs |
| Contents SKUs |
ID@parcels |
|
>
|
Contents SKUs |
| Contents Serials |
Serial@parcels |
|
>
|
Contents Serials |
| Qty |
Servie@parcels |
|
>
|
Qty |
| SSCC |
SSCC@parcels |
|
>
VARCHAR
|
Serial Shipping Container Code |
| Weight (kg) |
Poids@parcels |
|
>
DOUBLE
|
Weight (kg) |
| Hauteur (m) |
Hauteur@parcels |
|
>
DOUBLE
|
Hauteur (m) |
| Largeur (m) |
Largeur@parcels |
|
>
DOUBLE
|
Largeur (m) |
| Longueur (m) |
Longueur@parcels |
|
>
DOUBLE
|
Longueur (m) |
| Asset Name |
name@assets |
|
>
VARCHAR
|
Asset Name |
| Asset File |
file@assets |
|
>
|
Asset File |
