StoreFeeder Create Orders
Summary of Changes: (The purpose of this table is to keep traceability and Product team to highlight the things that were changed into the scope, based on comments or discussions)
| Version | Date | Created / Updated | Notes |
|---|---|---|---|
| v1.0 | 14/06/2023 | Hristiyan Georgiev | First publish |
| v1.1 | 30/11/2023 | Hristiyan Georgiev | Included IOSS number to be sent in the payload. |
| v1.2 | 04/01/2024 | Hristiyan Georgiev | Logic added for IOSS number to be excluded on any UK orders |
| v1.3 | 15/03/2024 | Hristiyan Georgiev | Removed discount from the mapping |
| v1.4 | 19/07/2024 | Milen Markov | Added a hardcoded IOSS for MP Cdiscount |
API Call : POST orders/create-orders-v2
We want to push order by order.
API Docs : https://rest.storefeeder.com/Help/Api/POST-orders-create-orders-v2
We want to create order in StoreFeeder when we have the order acknowledged, shipping cost splitted, debundled and the following statuses/flags :
Order > Order Status IN (Shipped, Ready For Shipping)Order > Connector Order ID = "" AND Product on Order > Connector Order ID = ""
Product on Order > Connector Exported = NoOrder > Connector Error = ""
Product on Order > Seller != ''
Example request :
[
{
"ChannelId": 1,
"ChannelOrderRef": "sample string 2",
"OrderTotals": {
"Subtotal": 1.0,
"Tax": 2.0,
"ShippingCost": 3.0,
"Discount": 4.0,
"Total": 5.0,
"ShippingNet": 6.0,
"ShippingTax": 7.0
},
"CustomerReference": "sample string 3",
"CustomerEmail": "sample string 4",
"BillingAddress": {
"FirstName": "sample string 1",
"LastName": "sample string 2",
"Company": "sample string 3",
"Address1": "sample string 4",
"Address2": "sample string 5",
"Address3": "sample string 6",
"Suite": "sample string 7",
"City": "sample string 8",
"State": "sample string 9",
"Postcode": "sample string 10",
"Country": "sample string 11",
"PhoneNumber": "sample string 12"
},
"ShippingAddress": {
"FirstName": "sample string 1",
"LastName": "sample string 2",
"Company": "sample string 3",
"Address1": "sample string 4",
"Address2": "sample string 5",
"Address3": "sample string 6",
"Suite": "sample string 7",
"City": "sample string 8",
"State": "sample string 9",
"Postcode": "sample string 10",
"Country": "sample string 11",
"PhoneNumber": "sample string 12"
},
"ShippingTotal": 5.0,
"OrderDate": "2023-06-08T12:17:26.5698261+00:00",
"PaymentMethod": "sample string 6",
"PaymentID": "sample string 7",
"ChannelShippingMethod": "sample string 8",
"SpecialInstructions": "sample string 9",
"CurrencyCode": "sample string 10",
"ExchangeRate": 1.0,
"IossNumber": "sample string 11",
"OrderLines": [
{
"OrderedProductSKU": "sample string 1",
"OrderedProductName": "sample string 2",
"QuantityOrdered": 3,
"SingleItemPrice": 4.0,
"TotalItemPriceExVat": 5.0,
"TotalItemPriceIncVat": 6.0,
"VatTotal": 7.0,
"TaxRate": 8.0,
"Discount": 1.0,
"ItemOptions": "sample string 9"
},
{
"OrderedProductSKU": "sample string 1",
"OrderedProductName": "sample string 2",
"QuantityOrdered": 3,
"SingleItemPrice": 4.0,
"TotalItemPriceExVat": 5.0,
"TotalItemPriceIncVat": 6.0,
"VatTotal": 7.0,
"TaxRate": 8.0,
"Discount": 1.0,
"ItemOptions": "sample string 9"
}
],
"ShipByDate": "2023-06-08T12:17:26.5854304+00:00"
}
]Mapping : Mapping: Please note N/A means we exclude it
| StoreFeeder Field | StoreFeeder Notes | Integration required | Hemi Mapping | Hemi Notes | |
|---|---|---|---|---|---|
ChannelId |
This is the Channel that the order was placed on. | Yes | Account StoreFeeder > Channel | integer | |
ChannelOrderRef |
This is the order reference that was supplied by the Channel. | Yes | Orders > Marketplace Order ID | string | |
OrderTotals |
This is the Order Total | ||||
Subtotal |
Subtotal of the Order (i.e. the value of the items ordered and shipping less tax) | No | Orders > Order Subtotal Amount | decimal number | |
Tax |
The tax for the order | No | Orders > Total Sales Tax |
| OR Orders > Total Vat OR Orders > Total Marketplace VAT | This would depend on Account > Country IF we have Account > Country = United States we use the Total Sales Tax field, IF we have Account > Country != United States we use Total Vat OR Total Marketplace VAT Total Marketplace VAT is with priority. | ShippingCost |
The total Shipping Cost for the order (including tax) | No | Orders > Shipping Service Cost | decimal number | Discount |
The discount applied at order level | No | <v1.3> N/A </v1.3> | decimal number | Total |
The total cost of the order (including tax, shipping and everything) | No | Orders > Order Total Amount | decimal number | ShippingNet |
The Net Shipping Cost for the order | No | Needs to be calculated : (Orders > Shipping Service Cost - Orders > Total Shipping Sales Tax) OR (Orders > Shipping Service Cost - Orders > Total Shipping VAT) OR (Orders > Shipping Service Cost - Orders > Total Shipping Marketplace VAT) | This would depend on Account > Country IF we have Account > Country = United States we use the Total Shipping Sales Tax field, IF we have Account > Country != United States we use Total Shipping Vat OR Total Shipping Marketplace VAT Total Shipping Marketplace VAT is with priority | ShippingTax |
The tax for the shipping of the order | No | Orders > Total Shipping Sales Tax OR Orders > Total Shipping VAT OR Orders > Total Shipping Marketplace VAT | This would depend on Account > Country IF we have Account > Country = United States we use the Total Shipping Sales Tax field, IF we have Account > Country != United States we use Total Shipping Vat OR Total Shipping Marketplace VAT Total Shipping Marketplace VAT is with priority | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CustomerReference |
This is the customer reference for the order. | No | N/A | |||||||||||||||||||||||||||||||||
CustomerEmail |
This is the customer email. | No | Orders > Buyer Mail | |||||||||||||||||||||||||||||||||
BillingAddress |
This is the billing address for the order. | Yes | ||||||||||||||||||||||||||||||||||
FirstName |
First name of the address | Orders > Billing Name | We need only the first name and we get everything before the first space character | |||||||||||||||||||||||||||||||||
| Trim leading white spaces if any | ||||||||||||||||||||||||||||||||||||
LastName |
Last name of the address. | Orders > Billing Name | We get everything after the first space character | |||||||||||||||||||||||||||||||||
| Trim leading white spaces if any | ||||||||||||||||||||||||||||||||||||
Company |
The company name of the address | Orders > Billing Company Name | Trim leading white spaces if any | |||||||||||||||||||||||||||||||||
Address1 |
Address line 1 for the address | Orders > Billing Street 1 | Trim leading white spaces if any | |||||||||||||||||||||||||||||||||
| If Billing Street 1 is empty, we use Billing Street 2 and send it as Address1 | ||||||||||||||||||||||||||||||||||||
Address2 |
Address line 2 for the address | Orders > Billing Street 2 | Trim leading white spaces if any | |||||||||||||||||||||||||||||||||
Address3 |
Address line 3 for the address | N/A | ||||||||||||||||||||||||||||||||||
Suite |
The Suite of the Address | N/A | ||||||||||||||||||||||||||||||||||
City |
The City of the Address | Orders > Billing City Name | Trim leading white spaces if any | |||||||||||||||||||||||||||||||||
State |
The County/State of the Address | Orders > Billing State Province | Trim leading white spaces if any | |||||||||||||||||||||||||||||||||
Postcode |
The Zip/Postcode of the Address | Orders > Billing Postal Code | Trim leading white spaces if any | |||||||||||||||||||||||||||||||||
Country |
The Country of the Address | Orders > Billing Country Name | Trim leading white spaces if any | |||||||||||||||||||||||||||||||||
PhoneNumber |
The Phone Number associated with the Address | Orders > Billing Phone | Trim everything except numbers and “+” sign | |||||||||||||||||||||||||||||||||
ShippingAddress |
This is the billing address for the order. | Yes | ||||||||||||||||||||||||||||||||||
FirstName |
First name of the address | Orders > Shipping Buyer Name | We need only the first name and we get everything before the first space character | |||||||||||||||||||||||||||||||||
| Trim leading white spaces if any | ||||||||||||||||||||||||||||||||||||
LastName |
Last name of the address. | Orders > Shipping Buyer Name | We get everything after the first space character | |||||||||||||||||||||||||||||||||
| Trim leading white spaces if any | ||||||||||||||||||||||||||||||||||||
Company |
The company name of the address | Orders > Shipping Company Name | Trim leading white spaces if any | |||||||||||||||||||||||||||||||||
Address1 |
Address line 1 for the address | Orders > Shipping Street 1 | Trim leading white spaces if any | |||||||||||||||||||||||||||||||||
| If Shipping Street 1 is empty, we use Shipping Street 2 and send it as Address1 | ||||||||||||||||||||||||||||||||||||
Address2 |
Address line 2 for the address | Orders > Shipping Street 2 | Trim leading white spaces if any | |||||||||||||||||||||||||||||||||
Address3 |
Address line 3 for the address | N/A | ||||||||||||||||||||||||||||||||||
Suite |
The Suite of the Address | N/A | ||||||||||||||||||||||||||||||||||
City |
The City of the Address | Orders > Shipping City | Trim leading white spaces if any | |||||||||||||||||||||||||||||||||
State |
The County/State of the Address | Orders > Shipping State Province | Trim leading white spaces if any | |||||||||||||||||||||||||||||||||
Postcode |
The Zip/Postcode of the Address | Orders > Shipping Postal Code | Trim leading white spaces if any | |||||||||||||||||||||||||||||||||
Country |
The Country of the Address | Orders > Shipping Country Name | Trim leading white spaces if any | |||||||||||||||||||||||||||||||||
PhoneNumber |
The Phone Number associated with the Address | Orders > Shipping Phone | Trim everything except numbers and “+” sign | |||||||||||||||||||||||||||||||||
ShippingTotal |
This is the total shipping cost. | No | Orders > Shipping Service Cost | |||||||||||||||||||||||||||||||||
OrderDate |
This is the date that the order was placed. This is returned in UTC time. | No | Orders > Order Created Time | Date format should be : | ||||||||||||||||||||||||||||||||
2023-06-08T12:17:26.5698261+00:00 |
||||||||||||||||||||||||||||||||||||
PaymentMethod |
This is the Payment Method that was used to pay for the order. | No | Orders > Order Payment Method | |||||||||||||||||||||||||||||||||
PaymentID |
This is the Payment ID that was assigned to the order. | No | Order Payment Details > Transaction ID | |||||||||||||||||||||||||||||||||
ChannelShippingMethod |
This is the shipping method information that the order Channel provided to StoreFeeder. | No | Orders > Shipping Service | |||||||||||||||||||||||||||||||||
SpecialInstructions |
This is a list of any special instructions that were stored against the order. | No | N/A | |||||||||||||||||||||||||||||||||
CurrencyCode |
This is the 3-character currency code of the order, e.g. GBP, USD | No | Orders > Order Currency |
OR
Account > Exchange Rate Calculator Currency | Must be 3-character currency code of the order, e.g. GBP, USD
Order Currency is with priority. We will only use Exchange Rate Calculator Currency if the Order Currency is empty. |
| ExchangeRate | | This is the exchange rate of the order currency to the default currency on the account at the time the order was imported into StoreFeeder. | No | N/A | |
| <v1.1>IossNumber | | This is the IOSS number (Import One-Stop Shop) for seamless cross-border transactions | No | Orders Ebay > Tax Reference
OR
Order Item Amazon > IOSS
OR
Orders Fruugo > Fruugo Tax ID
OR
’IM2500000295’ (hardcoded for Cdiscount) | This is the IOSS number we need to send and we store it on different places based on different marketplaces.
For eBay we are storing it in a format of "IOSS:IM2760000742" we need to truncate the “IOSS:" and just send the actual IOSS number.
For Amazon we want to pick the IOSS number from the product with the lowest ID.
If none of the fields is filled we just exclude it from the payload.</v1.1><v1.2> We need to also create a logic and NOT include the IossNumber node for orders that have shipping country code “GB” </v1.2>
<v1.4>We need to hardcode value IM2500000295 for Cdiscount marketplace orders </v1.4> |
| OrderLines | | | Yes | | |
| | OrderedProductSKU | This is the SKU that was received from channel. | | Product In Order > SKU | |
| | OrderedProductName | This is the Product name that was received from channel. | | Product In Order > Item Title | |
| | QuantityOrdered | The Original amount the customer ordered. | | Product In Order > Quantity | |
| | SingleItemPrice | The price of a single unit of a product | | Product In Order > Item Price | |
| | TotalItemPriceExVat | The total price of the order line excluding VAT | | Needs to be calculated.
(Product In Order > Item PriceProduct In Order > Quantity) - (Product In Order > Item Sales Tax PriceProduct In Order > Quantity)
OR
(Product In Order > Item PriceProduct In Order > Quantity) - (Product In Order > Vat Item PriceProduct In Order > Quantity)
OR
(Product In Order > Item PriceProduct In Order > Quantity) - (Product In Order > Marketplace VAT Item PriceProduct In Order > Quantity) | This would depend on Account > Country
IF we have Account > Country = United States we use the Item Sales Tax Price field,
IF we have Account > Country != United States we use Vat Item Price OR Marketplace VAT Item Price
Marketplace VAT Item Price is with priority |
| | TotalItemPriceIncVat | The total price of the order line including VAT | | Needs to be calculated.
Product In Order > Item PriceProduct In Order > Quantity | |
| | VatTotal | The VAT of the order line | | Needs to be calculated.
Product In Order > Item Sales Tax PriceProduct In Order > Quantity
OR
Product In Order > Vat Item PriceProduct In Order > Quantity
OR
Product In Order > Marketplace VAT Item PriceProduct In Order > Quantity | This would depend on Account > Country
IF we have Account > Country = United States we use the Item Sales Tax Price field,
IF we have Account > Country != United States we use Vat Item Price OR Marketplace VAT Item Price
Marketplace VAT Item Price is with priority |
| | TaxRate | The tax rate used to calculate the VAT | | Product In Order > Sales Tax Percent
OR
Product In Order > Vat Percent
OR
Product In Order > Marketplace VAT Percent | This would depend on Account > Country
IF we have Account > Country = United States we use the Item Sales Tax Percent field,
IF we have Account > Country != United States we use Vat Percent OR Marketplace VAT Percent
Marketplace VAT Percent is with priority |
| | Discount | The value of any discount applied to the order line | | <v1.3> N/A </v1.3> | |
| | ItemOptions | An optional order line customization | | N/A | |
| ShipByDate | | The date that this order should be shipped by | No | Orders > Ship By Date | Format should be :
2023-07-05T06:53:49.5391989+00:00 |
After successfully creating the order, we will receive a response from StoreFeeder in which they are basically giving us the same information for the order that we have sent, however there are a few nodes from the response which we need to take into consideration.
Example response :
[
{
"CreatedOrder": {
"ChannelId": 1,
"ChannelOrderRef": "sample string 2",
"OrderTotals": {
"Subtotal": 1.0,
"Tax": 2.0,
"ShippingCost": 3.0,
"Discount": 4.0,
"Total": 5.0,
"ShippingNet": 6.0,
"ShippingTax": 7.0
},
"CustomerReference": "sample string 3",
"CustomerEmail": "sample string 4",
"BillingAddress": {
"FirstName": "sample string 1",
"LastName": "sample string 2",
"Company": "sample string 3",
"Address1": "sample string 4",
"Address2": "sample string 5",
"Address3": "sample string 6",
"Suite": "sample string 7",
"City": "sample string 8",
"State": "sample string 9",
"Postcode": "sample string 10",
"Country": "sample string 11",
"PhoneNumber": "sample string 12"
},
"ShippingAddress": {
"FirstName": "sample string 1",
"LastName": "sample string 2",
"Company": "sample string 3",
"Address1": "sample string 4",
"Address2": "sample string 5",
"Address3": "sample string 6",
"Suite": "sample string 7",
"City": "sample string 8",
"State": "sample string 9",
"Postcode": "sample string 10",
"Country": "sample string 11",
"PhoneNumber": "sample string 12"
},
"ShippingTotal": 5.0,
"OrderDate": "2023-06-12T10:38:01.0290044+00:00",
"PaymentMethod": "sample string 6",
"PaymentID": "sample string 7",
"ChannelShippingMethod": "sample string 8",
"SpecialInstructions": "sample string 9",
"CurrencyCode": "sample string 10",
"ExchangeRate": 1.0,
"OrderLines": [
{
"OrderedProductSKU": "sample string 1",
"OrderedProductName": "sample string 2",
"QuantityOrdered": 3,
"SingleItemPrice": 4.0,
"TotalItemPriceExVat": 5.0,
"TotalItemPriceIncVat": 6.0,
"VatTotal": 7.0,
"TaxRate": 8.0,
"Discount": 1.0,
"ItemOptions": "sample string 9"
},
{
"OrderedProductSKU": "sample string 1",
"OrderedProductName": "sample string 2",
"QuantityOrdered": 3,
"SingleItemPrice": 4.0,
"TotalItemPriceExVat": 5.0,
"TotalItemPriceIncVat": 6.0,
"VatTotal": 7.0,
"TaxRate": 8.0,
"Discount": 1.0,
"ItemOptions": "sample string 9"
}
],
"ShipByDate": "2023-06-12T10:38:01.0290044+00:00"
},
"StoreFeederOrder": [
{
"OrderNumber": 1,
"OrderGuid": "5b054613-cccc-4f43-b705-0346c5131a11",
"OrderStatus": "Received",
"Warehouse": {
"WarehouseName": "sample string 1",
"WarehouseGuid": "1d13c400-69de-4ea5-92ed-0b1cd0644026",
"WarehouseID": 3
},
"Channel": {
"ChannelName": "sample string 1",
"ChannelType": "ASPDNSF",
"ChannelID": 2,
"ChannelGuid": "87fd764e-8a51-48b6-b052-d0338a39e669",
"IsActive": true,
"CustomField1": "sample string 4",
"CustomField2": "sample string 5"
},
"ChannelOrderRef": "sample string 3",
"ParentOrderNumber": 1,
"OrderTotals": {
"Subtotal": 1.0,
"Tax": 2.0,
"ShippingCost": 3.0,
"Discount": 4.0,
"Total": 5.0,
"ShippingNet": 6.0,
"ShippingTax": 7.0
},
"Customer": {
"CustomerID": 1,
"CustomerGuid": "e1d40008-a64a-4f8a-92b9-0ba2282c23bf",
"CustomerRef": "sample string 1",
"RegisterDate": "2023-06-12T10:38:01.0290044+00:00",
"Email": "sample string 2",
"FirstName": "sample string 3",
"LastName": "sample string 4",
"PhoneNumber": "sample string 5"
},
"BillingAddress": {
"FirstName": "sample string 1",
"LastName": "sample string 2",
"Company": "sample string 3",
"Address1": "sample string 4",
"Address2": "sample string 5",
"Address3": "sample string 6",
"Suite": "sample string 7",
"City": "sample string 8",
"State": "sample string 9",
"Postcode": "sample string 10",
"Country": "sample string 11",
"PhoneNumber": "sample string 12"
},
"Shippingaddress": {
"FirstName": "sample string 1",
"LastName": "sample string 2",
"Company": "sample string 3",
"Address1": "sample string 4",
"Address2": "sample string 5",
"Address3": "sample string 6",
"Suite": "sample string 7",
"City": "sample string 8",
"State": "sample string 9",
"Postcode": "sample string 10",
"Country": "sample string 11",
"PhoneNumber": "sample string 12"
},
"CouponCode": "sample string 4",
"OrderDate": "2023-06-12T10:38:01.0290044+00:00",
"AttentionIsRequired": true,
"AttentionRequiredMessage": "sample string 5",
"IOSSNumber": "sample string 6",
"IsPrime": true,
"IsPriority": true,
"IsAmazonBusiness": true,
"ImportDate": "2023-06-12T10:38:01.0290044+00:00",
"DespatchDate": "2023-06-12T10:38:01.0290044+00:00",
"DespatchSentToChannelDate": "2023-06-12T10:38:01.0290044+00:00",
"DespatchOnChannelDate": "2023-06-12T10:38:01.0290044+00:00",
"LastStatusChangeDate": "2023-06-12T10:38:01.0290044+00:00",
"PaymentMethod": "sample string 10",
"PaymentID": "sample string 11",
"ChannelShippingMethod": "sample string 12",
"ShippingMethod": {
"ShippingMethodID": 1,
"Name": "sample string 2",
"ServiceCode": "sample string 3"
},
"ShippingTrackingNumber": "sample string 13",
"ShippedVia": "sample string 14",
"ConsignmentNumber": "sample string 15",
"Weight": 16.0,
"NumberOfPackages": 1,
"Packaging": {
"PackagingID": 1,
"PackagingName": "sample string 1"
},
"PickerName": "sample string 17",
"PackerName": "sample string 18",
"PickwaveID": 1,
"PickerInstructions": "sample string 19",
"SpecialInstructions": "sample string 20",
"ContactNotes": [
{
"ContactNoteID": 1,
"Subject": "sample string 2",
"Body": "sample string 3",
"Date": "2023-06-12T10:38:01.0290044+00:00",
"ContactType": 1
},
{
"ContactNoteID": 1,
"Subject": "sample string 2",
"Body": "sample string 3",
"Date": "2023-06-12T10:38:01.0290044+00:00",
"ContactType": 1
}
],
"Currency": "sample string 21",
"ExchangeRate": 1.0,
"Transactions": [
{
"TransactionID": 1,
"TransactionRef": "sample string 2",
"Subtotal": 1.0,
"Total": 1.0,
"Discount": 1.0,
"Tax": 1.0,
"ShippingCost": 1.0,
"TransactionDate": "2023-06-12T10:38:01.0290044+00:00",
"TransactionMethod": "sample string 3"
},
{
"TransactionID": 1,
"TransactionRef": "sample string 2",
"Subtotal": 1.0,
"Total": 1.0,
"Discount": 1.0,
"Tax": 1.0,
"ShippingCost": 1.0,
"TransactionDate": "2023-06-12T10:38:01.0290044+00:00",
"TransactionMethod": "sample string 3"
}
],
"OrderLines": [
{
"Product": {
"ProductID": 1,
"SKU": "sample string 2"
},
"OrderedProductSKU": "sample string 1",
"ChannelSKU": "sample string 2",
"OrderedProductName": "sample string 3",
"QuantityOrdered": 4,
"QuantitySent": 5,
"QuantityReturned": 1,
"LineStatus": "Allocated",
"SingleItemPrice": 1.0,
"TotalItemPriceExVat": 1.0,
"TotalItemPriceIncVat": 1.0,
"VatTotal": 1.0,
"RegularPrice": 1.0,
"TaxRate": 1.0,
"Discount": 1.0,
"ScannedProductBarcode": "sample string 6",
"IsComponent": true,
"IsKit": true,
"TextOption": "sample string 9"
},
{
"Product": {
"ProductID": 1,
"SKU": "sample string 2"
},
"OrderedProductSKU": "sample string 1",
"ChannelSKU": "sample string 2",
"OrderedProductName": "sample string 3",
"QuantityOrdered": 4,
"QuantitySent": 5,
"QuantityReturned": 1,
"LineStatus": "Allocated",
"SingleItemPrice": 1.0,
"TotalItemPriceExVat": 1.0,
"TotalItemPriceIncVat": 1.0,
"VatTotal": 1.0,
"RegularPrice": 1.0,
"TaxRate": 1.0,
"Discount": 1.0,
"ScannedProductBarcode": "sample string 6",
"IsComponent": true,
"IsKit": true,
"TextOption": "sample string 9"
}
],
"CancelledDateUTC": "2023-06-12T10:38:01.0290044+00:00",
"CompanyIdentity": {
"CompanyIdentityID": 1,
"CompanyIdentityName": "sample string 2"
}
},
{
"OrderNumber": 1,
"OrderGuid": "5b054613-cccc-4f43-b705-0346c5131a11",
"OrderStatus": "Received",
"Warehouse": {
"WarehouseName": "sample string 1",
"WarehouseGuid": "1d13c400-69de-4ea5-92ed-0b1cd0644026",
"WarehouseID": 3
},
"Channel": {
"ChannelName": "sample string 1",
"ChannelType": "ASPDNSF",
"ChannelID": 2,
"ChannelGuid": "87fd764e-8a51-48b6-b052-d0338a39e669",
"IsActive": true,
"CustomField1": "sample string 4",
"CustomField2": "sample string 5"
},
"ChannelOrderRef": "sample string 3",
"ParentOrderNumber": 1,
"OrderTotals": {
"Subtotal": 1.0,
"Tax": 2.0,
"ShippingCost": 3.0,
"Discount": 4.0,
"Total": 5.0,
"ShippingNet": 6.0,
"ShippingTax": 7.0
},
"Customer": {
"CustomerID": 1,
"CustomerGuid": "e1d40008-a64a-4f8a-92b9-0ba2282c23bf",
"CustomerRef": "sample string 1",
"RegisterDate": "2023-06-12T10:38:01.0290044+00:00",
"Email": "sample string 2",
"FirstName": "sample string 3",
"LastName": "sample string 4",
"PhoneNumber": "sample string 5"
},
"BillingAddress": {
"FirstName": "sample string 1",
"LastName": "sample string 2",
"Company": "sample string 3",
"Address1": "sample string 4",
"Address2": "sample string 5",
"Address3": "sample string 6",
"Suite": "sample string 7",
"City": "sample string 8",
"State": "sample string 9",
"Postcode": "sample string 10",
"Country": "sample string 11",
"PhoneNumber": "sample string 12"
},
"Shippingaddress": {
"FirstName": "sample string 1",
"LastName": "sample string 2",
"Company": "sample string 3",
"Address1": "sample string 4",
"Address2": "sample string 5",
"Address3": "sample string 6",
"Suite": "sample string 7",
"City": "sample string 8",
"State": "sample string 9",
"Postcode": "sample string 10",
"Country": "sample string 11",
"PhoneNumber": "sample string 12"
},
"CouponCode": "sample string 4",
"OrderDate": "2023-06-12T10:38:01.0290044+00:00",
"AttentionIsRequired": true,
"AttentionRequiredMessage": "sample string 5",
"IOSSNumber": "sample string 6",
"IsPrime": true,
"IsPriority": true,
"IsAmazonBusiness": true,
"ImportDate": "2023-06-12T10:38:01.0290044+00:00",
"DespatchDate": "2023-06-12T10:38:01.0290044+00:00",
"DespatchSentToChannelDate": "2023-06-12T10:38:01.0290044+00:00",
"DespatchOnChannelDate": "2023-06-12T10:38:01.0290044+00:00",
"LastStatusChangeDate": "2023-06-12T10:38:01.0290044+00:00",
"PaymentMethod": "sample string 10",
"PaymentID": "sample string 11",
"ChannelShippingMethod": "sample string 12",
"ShippingMethod": {
"ShippingMethodID": 1,
"Name": "sample string 2",
"ServiceCode": "sample string 3"
},
"ShippingTrackingNumber": "sample string 13",
"ShippedVia": "sample string 14",
"ConsignmentNumber": "sample string 15",
"Weight": 16.0,
"NumberOfPackages": 1,
"Packaging": {
"PackagingID": 1,
"PackagingName": "sample string 1"
},
"PickerName": "sample string 17",
"PackerName": "sample string 18",
"PickwaveID": 1,
"PickerInstructions": "sample string 19",
"SpecialInstructions": "sample string 20",
"ContactNotes": [
{
"ContactNoteID": 1,
"Subject": "sample string 2",
"Body": "sample string 3",
"Date": "2023-06-12T10:38:01.0290044+00:00",
"ContactType": 1
},
{
"ContactNoteID": 1,
"Subject": "sample string 2",
"Body": "sample string 3",
"Date": "2023-06-12T10:38:01.0290044+00:00",
"ContactType": 1
}
],
"Currency": "sample string 21",
"ExchangeRate": 1.0,
"Transactions": [
{
"TransactionID": 1,
"TransactionRef": "sample string 2",
"Subtotal": 1.0,
"Total": 1.0,
"Discount": 1.0,
"Tax": 1.0,
"ShippingCost": 1.0,
"TransactionDate": "2023-06-12T10:38:01.0290044+00:00",
"TransactionMethod": "sample string 3"
},
{
"TransactionID": 1,
"TransactionRef": "sample string 2",
"Subtotal": 1.0,
"Total": 1.0,
"Discount": 1.0,
"Tax": 1.0,
"ShippingCost": 1.0,
"TransactionDate": "2023-06-12T10:38:01.0290044+00:00",
"TransactionMethod": "sample string 3"
}
],
"OrderLines": [
{
"Product": {
"ProductID": 1,
"SKU": "sample string 2"
},
"OrderedProductSKU": "sample string 1",
"ChannelSKU": "sample string 2",
"OrderedProductName": "sample string 3",
"QuantityOrdered": 4,
"QuantitySent": 5,
"QuantityReturned": 1,
"LineStatus": "Allocated",
"SingleItemPrice": 1.0,
"TotalItemPriceExVat": 1.0,
"TotalItemPriceIncVat": 1.0,
"VatTotal": 1.0,
"RegularPrice": 1.0,
"TaxRate": 1.0,
"Discount": 1.0,
"ScannedProductBarcode": "sample string 6",
"IsComponent": true,
"IsKit": true,
"TextOption": "sample string 9"
},
{
"Product": {
"ProductID": 1,
"SKU": "sample string 2"
},
"OrderedProductSKU": "sample string 1",
"ChannelSKU": "sample string 2",
"OrderedProductName": "sample string 3",
"QuantityOrdered": 4,
"QuantitySent": 5,
"QuantityReturned": 1,
"LineStatus": "Allocated",
"SingleItemPrice": 1.0,
"TotalItemPriceExVat": 1.0,
"TotalItemPriceIncVat": 1.0,
"VatTotal": 1.0,
"RegularPrice": 1.0,
"TaxRate": 1.0,
"Discount": 1.0,
"ScannedProductBarcode": "sample string 6",
"IsComponent": true,
"IsKit": true,
"TextOption": "sample string 9"
}
],
"CancelledDateUTC": "2023-06-12T10:38:01.0290044+00:00",
"CompanyIdentity": {
"CompanyIdentityID": 1,
"CompanyIdentityName": "sample string 2"
}
}
],
"Success": true,
"Error": "sample string 2"
}
]Mapping : We dont want to map anything apart from StoreFeederOrder and Error. We exclude everything else
| StoreFeeder Field | StoreFeeder Notes | Hemi Mapping | Hemi Notes | |
|---|---|---|---|---|
StoreFeederOrder |
The order that was created in StoreFeeder | |||
OrderNumber |
This is the StoreFeeder Order Number. | Orders > Connector Order ID |
AND
Product in Order > Connector ID | We want to store the StoreFeeder Order number into the Orders > Connector Order ID and Product in Order > Connector ID |
| Success | | Whether the order creation was successful | | If true we store the StoreFeeder Order number into Orders > Connector Order ID
If false we store the error in Orders > Connector Error AND Order Error with type “Connector” |
| Error | | Any errors that were received Success will always be false if an error is returned. | Orders > Connector Error | |
After successful order creation we will need to update also Order Item > Connector Exported field = Yes