{"type":"doc","content":[{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":960,"id":"48065c92-0351-4695-a8f9-2a4a282dcca3","collection":"contentId-3858333697","type":"file","height":210}}]},{"type":"paragraph"},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The event sent from Platform for import_orders:","type":"text"}]}]}]},{"type":"codeBlock","content":[{"text":"{\n \"resource\": \"import_job\",\n \"eventType\": \"POST\",\n \"eventSubType\": \"processing\",\n \"accountSlug\": \"welspun\",\n \"email\": \"anuradha.tyagi@eshopbox.com\",\n \"geoIp\": {\n \"country_code\": \"IN\",\n \"country_code3\": \"IND\",\n \"country_name\": \"India\",\n \"city_name\": \"Delhi\",\n \"latitude\": 28.6542,\n \"longitude\": 77.2373,\n \"time_zone\": \"Asia/Kolkata\",\n \"continent_code\": \"AS\",\n \"subdivision_code\": \"DL\",\n \"subdivision_name\": \"National Capital Territory of Delhi\",\n \"ip\": \"180.151.80.22\"\n },\n \"version\": \"v1\",\n \"responseData\": {\n \"id\": 38780,\n \"jobType\": \"order\",\n \"channelId\": 0,\n \"userName\": \"anuradha.tyagi@eshopbox.com\",\n \"userId\": 2787,\n \"filePath\": \"https://cdn.filestackcontent.com/tFw135FsQmW6ThRzNbFY\",\n \"status\": \"0\",\n \"warehouseCode\": \"DELKH004\",\n \"createdAt\": \"Oct 7, 2022 4:57:37 PM\",\n \"updatedAt\": \"Oct 7, 2022 4:57:37 PM\"\n },\n \"machineOS\": \"Windows\"\n}","type":"text"}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"2. Push only the events with this jobType further in the queue. Give a 200OK response for all the events with jobtype other than ‘order’.","type":"text"}]},{"type":"paragraph","content":[{"text":"TaskQueue name: order_import","type":"text"}]},{"type":"paragraph","content":[{"text":"TaskQueueListener: /_ah/api/esb/v1/importorders","type":"text"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"Note: Create Auth token from API and send it further with the event.","type":"text"}]}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"3. In the first task queue listener, read the CSV and group the data w.r.t orders. Check if the orders are already created in DB. Use the below query to fetch the data of orders.","type":"text"}]},{"type":"codeBlock","content":[{"text":"SELECT customerOrderNumber FROM orders WHERE channel_id =:channelId AND customerOrderNumber IN (:customerOrderNumber)","type":"text"}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"4. If the order is already created in DB add the order to the failure count and generate a failure sheet and update the same in DB.","type":"text"}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"5. Divide the remaining unique customer order numbers which are not fetched from the above query into batch of 30 and push it further in the 2nd queue.","type":"text"}]},{"type":"paragraph","content":[{"text":"TaskQueue name: order_import","type":"text"}]},{"type":"paragraph","content":[{"text":"TaskQueueListener: importorders/listener","type":"text"}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"6. In the second queue, validate the headers and the orders data. If the CSV is invalid sent a failure request to the platform API and update the failure reason in the sheet as well. Pass the CSV in additionalDetails","type":"text"}]},{"type":"paragraph","content":[{"text":"URL: ","type":"text"},{"text":"https://{{accountSlug}}.eshopbox.com/_ah/api/esb/v1/import-job","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ffffff"}},{"type":"link","attrs":{"href":"https://workspace.eshopbox.com/_ah/api/esb/v1/_ah/api/esb/v1/import-job/2650"}}]},{"text":"/","type":"text"}]},{"type":"paragraph","content":[{"text":"Headers: ","type":"text"}]},{"type":"table","attrs":{"layout":"default","localId":"13fc1787-7d91-4a2b-833f-a3aba3e76ce4"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Header","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Value","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Authorization","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Bearer ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"ProxyHost","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"","type":"text"}]}]}]}]},{"type":"paragraph","content":[{"text":" request body: ","type":"text"}]},{"type":"codeBlock","content":[{"text":"{\n\"jobType\":\"import_order\",\n\"additionalDetails\":\"djkschsjcbhsdbhvcusvvcxznoixjASIXkzm\",\n\"status\":\"2\",\n\"successCount\":10,\n\"failureCount\":3\n}","type":"text"}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"7. Do the transformation for create order API and call the API to create order. ","type":"text"}]},{"type":"paragraph","content":[{"text":"For getting the value of itemID and MRP, we call the below Product API: ","type":"text"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"Check if product is marked available for the particular channel. ","type":"text"},{"type":"hardBreak"},{"text":"Document link: ","type":"text"},{"type":"inlineCard","attrs":{"url":"https://auperator.atlassian.net/wiki/spaces/POE/pages/edit-v2/3875241993"}},{"text":" ","type":"text"}]}]},{"type":"paragraph","content":[{"text":"API: GET","type":"text"}]},{"type":"paragraph","content":[{"text":"URL: ","type":"text"},{"text":"https://products-dot-esb-product-engine-prod.appspot.com/_ah/api/esb/v1/products?fields=groupCode,components,status,accountSlug,additionalNames,esin,description,mrp,hsnCode,combo,imageUrl,channelCode,verticalName,brand,type,sku,weight,dimensionHeight,dimensionLength,dimensionWidth,weightUnit,dimensionUnit,properties&ids","type":"text","marks":[{"type":"link","attrs":{"href":"https://products-dot-esb-product-engine-prod.appspot.com/_ah/api/esb/v1/products?fields=groupCode,components,status,accountSlug,additionalNames,esin,description,mrp,hsnCode,combo,imageUrl,channelCode,verticalName,brand,type,sku,weight,dimensionHeight,dimensionLength,dimensionWidth,weightUnit,dimensionUnit,properties&ids=02LMX3H7CIS'"}}]},{"text":"= ","type":"text"}]},{"type":"paragraph","content":[{"text":"Headers:","type":"text"}]},{"type":"table","attrs":{"layout":"default","localId":"bd585149-7242-4f9b-a16a-c2057acd3b9b"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Header name","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Value","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Authorization","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Bearer ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Content-Type","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"application/json","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"proxyHost","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"","type":"text"}]}]}]}]},{"type":"paragraph","content":[{"text":"Sample response:","type":"text"}]},{"type":"codeBlock","content":[{"text":"{\n \"02LMX3H7CIS\": {\n \"hsnCode\": \"61091000\",\n \"dimensionHeight\": 6.0,\n \"dimensionLength\": 11.0,\n \"dimensionUnit\": \"cm\",\n \"description\": \"COVER STORYWomen Tshirt\",\n \"weight\": 250.0,\n \"mrp\": 1290.0,\n \"dimensionWidth\": 12.0,\n \"type\": \"BASE\",\n \"verticalName\": \"Apparels\",\n \"imageUrl\": \"https://i.postimg.cc/dt2Z7yhH/TSTE06-UB1161-TE.jpg\",\n \"accountSlug\": \"coverstory\",\n \"sku\": \"1002707978002\",\n \"esin\": \"02LMX3H7CIS\",\n \"brand\": \"Cover Story\",\n \"additionalNames\": {\n \"ean\": \"8907760305753\",\n \"upc\": \"1002707978002\",\n \"others\": [\n \"TSTE06UB1161-TES\"\n ]\n },\n \"properties\": [\n {\n \"label\": \"Ajio publishing error\",\n \"internalName\": \"Ajio publishing error\",\n \"value\": [\n \"Duplicity error\"\n ]\n },\n {\n \"label\": \"Ajio publishing notes\",\n \"internalName\": \"Ajio publishing notes\",\n \"value\": [\n \"Duplicate: This EAN already present in system with a different commercial model. Please do not upload again.\"\n ]\n },\n {\n \"label\": \"Ajio publishing status\",\n \"internalName\": \"Ajio publishing status\",\n \"value\": [\n \"Failed\"\n ]\n },\n {\n \"label\": \"Nykaa publishing error\",\n \"internalName\": \"Nykaa publishing error\",\n \"value\": [\n \"-\"\n ]\n },\n {\n \"label\": \"Nykaa publishing notes\",\n \"internalName\": \"Nykaa publishing notes\",\n \"value\": [\n \"-\"\n ]\n },\n {\n \"label\": \"Nykaa publishing status\",\n \"internalName\": \"Nykaa publishing status\",\n \"value\": [\n \"Published\"\n ]\n },\n {\n \"label\": \"Nykaa sku code\",\n \"internalName\": \"Nykaa sku code\",\n \"value\": [\n \"COVER00002827\"\n ]\n },\n {\n \"label\": \"Tatacliq MPcode\",\n \"internalName\": \"Tatacliq MPcode\",\n \"value\": [\n \"MP000000014459509\"\n ]\n },\n {\n \"label\": \"Tatacliq Request_ID\",\n \"internalName\": \"Tatacliq Request_ID\",\n \"value\": [\n \"Ticke ID: CW-26808\"\n ]\n },\n {\n \"label\": \"Tatacliq publishing status\",\n \"internalName\": \"Tatacliq publishing status\",\n \"value\": [\n \"Published\"\n ]\n },\n {\n \"label\": \"Tatacliq publishing error\",\n \"internalName\": \"Tatacliq publishing error\",\n \"value\": [\n \"-\"\n ]\n },\n {\n \"label\": \"Tatacliq_pipefy id\",\n \"internalName\": \"Tatacliq_pipefy id\",\n \"value\": [\n \"573814116\"\n ]\n },\n {\n \"label\": \"Ajio request ID\",\n \"internalName\": \"Ajio request ID\",\n \"value\": [\n \"1aea5ef3-9473-4ee0-9bf3-cc190a0574bb\"\n ]\n },\n {\n \"label\": \"Ajio_pipefy id\",\n \"internalName\": \"Ajio_pipefy id\",\n \"value\": [\n \"573814116\"\n ]\n },\n {\n \"label\": \"Brand Color\",\n \"internalName\": \"Brand Color\",\n \"value\": [\n \"Teal\"\n ]\n },\n {\n \"label\": \"Collar Neck\",\n \"internalName\": \"Collar Neck\",\n \"value\": [\n \"Round Neck\"\n ]\n },\n {\n \"label\": \"Color\",\n \"internalName\": \"Color\",\n \"value\": [\n \"Teal\"\n ]\n },\n {\n \"label\": \"Country of origin\",\n \"internalName\": \"Country of origin\",\n \"value\": [\n \"India\"\n ]\n },\n {\n \"label\": \"Description\",\n \"internalName\": \"Description\",\n \"value\": [\n \"Teal tee featuring round neckline and short sleeves with graphic statement \\\" Empowered\\\"\"\n ]\n },\n {\n \"label\": \"EAN Code\",\n \"internalName\": \"EAN Code\",\n \"value\": [\n \"8907760305753\"\n ]\n },\n {\n \"label\": \"Fashion Core\",\n \"internalName\": \"Fashion Core\",\n \"value\": [\n \"Fashion\"\n ]\n },\n {\n \"label\": \"Gender\",\n \"internalName\": \"Gender\",\n \"value\": [\n \"Women\"\n ]\n },\n {\n \"label\": \"MRP\",\n \"internalName\": \"MRP\",\n \"value\": [\n \"1290\"\n ]\n },\n {\n \"label\": \"Manufacturer Details\",\n \"internalName\": \"manufacturer details\",\n \"value\": [\n \"Future style lab,A-69, Second Floor, Okhla, New Delhi, Delhi 110020\"\n ]\n },\n {\n \"label\": \"Nykaa_pipefy id\",\n \"internalName\": \"Nykaa_pipefy id\",\n \"value\": [\n \"573814116\"\n ]\n },\n {\n \"label\": \"Occassion\",\n \"internalName\": \"Occassion\",\n \"value\": [\n \"Smart Casual\"\n ]\n },\n {\n \"label\": \"Product Name\",\n \"internalName\": \"Product Name\",\n \"value\": [\n \"Empowered Tee\"\n ]\n },\n {\n \"label\": \"Reversible\",\n \"internalName\": \"Reversible\",\n \"value\": [\n \"No\"\n ]\n },\n {\n \"label\": \"Sleeve\",\n \"internalName\": \"Sleeve\",\n \"value\": [\n \"Short\"\n ]\n },\n {\n \"label\": \"Stretch\",\n \"internalName\": \"Stretch\",\n \"value\": [\n \"Non Stretchable\"\n ]\n },\n {\n \"label\": \"Wash Care\",\n \"internalName\": \"Wash Care\",\n \"value\": [\n \"Hand Wash Separately, Normal Cycle, Do Not Bleach, Line Dry, Medium Low\"\n ]\n },\n {\n \"label\": \"fabric\",\n \"internalName\": \"Fabric\",\n \"value\": [\n \"Cotton\"\n ]\n },\n {\n \"label\": \"fit\",\n \"internalName\": \"Fit\",\n \"value\": [\n \"Regular\"\n ]\n },\n {\n \"label\": \"pattern\",\n \"internalName\": \"Pattern\",\n \"value\": [\n \"Solid\"\n ]\n },\n {\n \"label\": \"season\",\n \"internalName\": \"Season\",\n \"value\": [\n \"Fall Winter\"\n ]\n },\n {\n \"label\": \"product_color\",\n \"internalName\": \"product_color\",\n \"value\": [\n \"TEAL\"\n ]\n },\n {\n \"label\": \"product_size\",\n \"internalName\": \"product_size\",\n \"value\": [\n \"S\"\n ]\n },\n {\n \"label\": \"Myntra sku id\",\n \"internalName\": \"Myntra sku id\",\n \"value\": [\n \"8907760305753\"\n ]\n },\n {\n \"label\": \"SKU on Tatacliq\",\n \"internalName\": \"SKU on Tatacliq\",\n \"value\": [\n \"8907760305753\"\n ]\n },\n {\n \"label\": \"SKU_code_on_Unicommerce_927\",\n \"internalName\": \"SKU_code_on_Unicommerce_927\",\n \"value\": [\n \"02LMX3H7CIS\"\n ]\n }\n ],\n \"groupCode\": \"TSTE06UB1161-TE\",\n \"status\": \"ACTIVE\",\n \"weightUnit\": \"g\"\n }\n}","type":"text"}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":3},"content":[{"text":"Logics for certain key values:","type":"text"}]},{"type":"paragraph","content":[{"text":"ThirPartyShipping","type":"text","marks":[{"type":"strong"}]},{"text":": check for the Forward shipping provider in CSV sheet. If blank, Eshopbox is the shipping provider.","type":"text"}]},{"type":"table","attrs":{"layout":"default","localId":"d676bbb7-01a9-43a0-89ad-c201aa9b1739"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"third party shipping values","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Shipping provider","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph"}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"true","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Eshopbox","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph"}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"false","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Mentioned in sheet(Forward shipping provider)","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph"}]}]}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"LineItemSequenceNumber","type":"text","marks":[{"type":"strong"}]},{"text":": If present in the sheet, use that value else auto-generate the number from 1 for each order_item in order.","type":"text"}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"externalWarehouseId","type":"text","marks":[{"type":"strong"}]},{"text":": If user has selected fulfillmentLocation, use it else ignore this key.","type":"text"}]},{"type":"table","attrs":{"layout":"default","localId":"723a8cce-138d-435f-a22f-6ec8c7888536"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Key in create order API","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"key in event received from Platform","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"externalWarehouseID","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"responseData","type":"text","marks":[{"type":"code"}]},{"text":".warehouseCode","type":"text"}]}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":66.0},"content":[{"type":"media","attrs":{"width":818,"id":"3f3e1c8e-6fe6-4ee1-a75f-5869d5c8a82a","collection":"contentId-3858333697","type":"file","height":572}},{"type":"caption","content":[{"text":"Front-end view of selecting a fulfillment location","type":"text"}]}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"Key mapping for create order API: ","type":"text"}]},{"type":"table","attrs":{"layout":"default","localId":"724564b2-5608-4e61-bd5c-a43a06a29d11"},"content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#f4f5f7","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"WMS Create Order Keys","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#f4f5f7","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Order Sheet Keys","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"externalChannelID","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"externalChannelID","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"customerOrderNumber","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"orderSheet.ChannelOrderId","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"expectedShipDate","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"orderSheet.Expected ready to ship","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"vendorOrderNumber","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"orderSheet.CustomerOrderId","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"shipMethod","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"“STD”","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"orderDate","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"orderSheet.OrderDate","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"isCOD","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"If orderSheet.PaymentMethod == “COD“?1:0","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"paymentType","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"orderSheet.PaymentMethod","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"balanceDue","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"thirdPartyShipping","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"true - if Eshopbox as shipping provider","type":"text"},{"type":"hardBreak"},{"text":"else false","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"shippingAddress.customerName","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"orderSheet.shippingCustomerName","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"taxAmount","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"0","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"shippingAddress.addressLine1","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"orderSheet.ShippingAddress","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"shippingAddress.addressLine2","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"shippingAddress.city","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"orderSheet.shippingCity","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"shippingAddress.postalCode","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"orderSheet.shippingPinCode","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"shippingAddress.countryCode","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"orderSheet.shippingCountry","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"shippingAddress.countryName","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"India","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"shippingAddress.contactPhone","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"orderSheet.shippingContactNumber","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"shippingAddress.email","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":" ","type":"text"},{"text":"orderSheet.shippingEmail","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"shippingAddress.state","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"orderSheet.shippingState","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"billingAddress.customerName","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"same as of shippingAddress","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"billingAddress.addressLine1","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"same as of shippingAddress","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"billingAddress.addressLine2","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"same as of shippingAddress","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"billingAddress.city","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"same as of shippingAddress","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"billingAddress.postalCode","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"same as of shippingAddress","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"billingAddress.countryCode","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"same as of shippingAddress","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"billingAddress.countryName","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"same as of shippingAddress","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"billingAddress.contactPhone","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"same as of shippingAddress","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"billingAddress.email","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"same as of shippingAddress","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"billingAddress.state","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"same as of shippingAddress","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"items[].lineItemSequenceNumber","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"orderSheet.OrderItemID","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"items[].quantity","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"orderSheet.Quantity","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"items[].itemID","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":" From response of Product API","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"items[].productName","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"orderSheet.title","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"items[].customerPrice","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"MRP+ ","type":"text"},{"text":"taxAmount","type":"text","marks":[{"type":"code"}]},{"text":" ( from product API )","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"items[].giftWrapCharges","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"orderSheet.otherCharges","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"items[].discount","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"customerPrice(MRP)*quantites - (sellingPrice) (inculsive of quantities)","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"items[].lineItemTotal","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"(orderSheet.sellingPrice - discount)","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"items[].taxAmount","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"0","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"items[].giftMessage","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"orderSheet.GiftMessage","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"items[].giftLabelContent","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":" ","type":"text"}]},{"type":"paragraph","content":[{"text":"items[].isGift","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"orderSheet.GiftWrap == “YES” ? 1:0","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"items[].invoiceNumber","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"orderSheet.InvoiceNumber","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"items[].sku","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"ESIN from response of product API","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"items[].externalWarehouseID","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"responseData.warehouseCode","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"shipChargeAmount","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"sum of all orderSheet.ShippingCharges","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"subTotal","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"sum of all lineItemTotal","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"orderTotal","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"subTotal + shipChargeAmount + otherCharges","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"suggestedCourierCode","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Forward shipping provider","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"externalWarehouseID","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"responseData.warehouseCode","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"suggestedTrackingNumber","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Forward tracking number","type":"text"}]}]}]}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"URL : ","type":"text"},{"text":"https://{{workspace}}.eshopbox.com/api/order","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ffffff"}},{"type":"link","attrs":{"href":"https://welspun.eshopbox.com/api/order"}}]}]},{"type":"paragraph","content":[{"text":"Headers:","type":"text"}]},{"type":"table","attrs":{"layout":"default","localId":"530d8a5a-be5f-42c2-940e-69a037129bc9"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Header name","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Value","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Authorization","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Bearer ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Content-Type","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"application/json","type":"text"}]}]}]}]},{"type":"paragraph","content":[{"text":"Sample request body:","type":"text"}]},{"type":"codeBlock","content":[{"text":"{\n \"vendorOrderNumber\": \"Test-04\",\n \"balanceDue\": 0,\n \"externalChannelID\": \"CH2065\",\n \"orderSiteID\": \"MAGENTO2\",\n \"expectedShipDate\": \"2022-09-15 11:13:00\",\n \"customerOrderNumber\": \"Test-04\",\n \"orderTotal\": 1119.60,\n \"paymentType\": \"Prepaid\",\n \"isCOD\": \"0\",\n \"subtotal\": 1119.60,\n \"shipMethod\": \"STD\",\n \"shippingAddress\": {\n \"city\": \"KOLKATA\",\n \"countryCode\": \"IN\",\n \"postalCode\": \"700063\",\n \"addressLine1\": \"TEST\",\n \"addressLine2\": \"\",\n \"state\": \"WB\",\n \"countryName\": \"IN\",\n \"contactPhone\": \"8802064263\",\n \"customerName\": \"TEST\",\n \"email\": \"\"\n },\n \"thirdPartyShipping\": true,\n \"billingAddress\": {\n \"city\": \"KOLKATA\",\n \"countryCode\": \"IN\",\n \"postalCode\": \"700063\",\n \"addressLine1\": \"TEST\",\n \"addressLine2\": \"\",\n \"state\": \"WB\",\n \"countryName\": \"IN\",\n \"contactPhone\": \"8802064263\",\n \"customerName\": \"TEST\",\n \"email\": \"\"\n },\n \"taxAmount\": 0,\n \"orderDate\": \"2022-09-13 17:08:00\",\n \"items\": [\n {\n \"productImageUrl\": \"\",\n \"itemID\": \"1059692\",\n \"quantity\": 1,\n \"customerOrderItemID\": \"1\",\n \"lineItemSequenceNumber\": \"1\",\n \"lineItemTotal\": 1184.47,\n \"productUrl\": \"\",\n \"customerPrice\": 1184.47,\n \"externalWarehouseID\": \"Eshopbox_Mumbai\",\n \"productName\": \"Spaces Orthopedic Mattress\"\n },\n {\n \"productImageUrl\": null,\n \"itemID\": \"1052739\",\n \"quantity\": 1,\n \"customerOrderItemID\": \"1\",\n \"lineItemSequenceNumber\": \"1\",\n \"lineItemTotal\": 1184.47,\n \"productUrl\": null,\n \"customerPrice\": 1184.47,\n \"externalWarehouseID\": \"Eshopbox_Mumbai\",\n \"productName\": \"SPACES BONICA 100% COTTON Single Bedsheet Air Purifying Anti-bacterial Soft Feel Skin Safe (FLORAL,\"\n }\n ],\n \"shipChargeAmount\": 0.0\n}'","type":"text"}]},{"type":"paragraph"},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"Note: Do not call create order API if replacementOrderItemId contains some value.","type":"text"}]}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":3},"content":[{"text":"Case of Replacement for order item id: ","type":"text"}]},{"type":"paragraph","content":[{"text":"If we get a value in replacementOrderItemId in the sheet, run the below query to fetch the order_items.id(primary key), original_order_item_id, previous_order_item_id from DB.","type":"text"}]},{"type":"codeBlock","content":[{"text":"SELECT order_items.id, original_order_item_id AS originalOrderItemId, previous_order_item_id AS previourOrderItemId FROM order_items \nLEFT JOIN orders ON orders.id = order_items.order_id\nLEFT JOIN channels ON channels.id = orders.channel_id\nWHERE orders.customerOrderNumber =:customerOrderNumber AND channels.externalChannelID =:externalChannelID\nAND order_items.lineItemSequenceNumber =:replacementOrderItemId","type":"text"}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"Conditions:","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If the values of original_order_item_id and previous_order_item_id got from DB are ","type":"text"},{"text":"null","type":"text","marks":[{"type":"strong"}]},{"text":", put the value of order_items.id in original_order_item_id and previous_order_item_id and save the values in order_items.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If the values of original_order_item_id and previous_order_item_id exists in DB, put the value of order_items.id in previous_order_item_id and keep the original_order_item_id as it is. ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Update the values in order_items table. ","type":"text"}]},{"type":"paragraph","content":[{"text":"To create shipment make the below event and push it to the mentioned topic.","type":"text"}]},{"type":"paragraph","content":[{"text":"project: eshopbox-wms-staging","type":"text"}]},{"type":"paragraph","content":[{"text":"Topic: ","type":"text"}]},{"type":"paragraph","content":[{"text":"staging- wms_shipment_create_api","type":"text"}]},{"type":"paragraph","content":[{"text":"prod-","type":"text"}]},{"type":"paragraph","content":[{"text":"Event:","type":"text"}]},{"type":"codeBlock","content":[{"text":"{\n \"account_slug\": \"kalkifashion\",\n \"account_id\": \"655\",\n \"integrationType\": \"13\",\n \"order_data\": {\n \"vendorOrderNumber\": \"1100156405\",\n \"onHold\": \"0\",\n \"balanceDue\": 0.0,\n \"externalChannelID\": \"CH2018\",\n \"packageID\": \"\",\n \"orderStatus\": \"created\",\n \"customerOrderNumber\": \"MUM000000154\",\n \"orderTotal\": 50.0,\n \"paymentType\": \"Prepaid\",\n \"isCOD\": \"0\",\n \"subtotal\": 50.0,\n \"shipMethod\": \"STD\",\n \"shippingAddress\": {\n \"city\": \"Birmingham\",\n \"countryCode\": \"IN\",\n \"postalCode\": \"B742DG\",\n \"addressLine1\": \"4 Mayland Drive Sutton Coldfield\",\n \"addressLine2\": \"Test Address\",\n \"countryName\": \"GREAT BRITAIN (United Kingdom)\",\n \"state\": \"West midlands\",\n \"contactPhone\": \"07470021520\",\n \"customerName\": \"Gurjit Kaur\",\n \"email\": \"gurj180@gmail.com\"\n },\n \"thirdPartyShipping\": false,\n \"billingAddress\": {\n \"city\": \"Birmingham\",\n \"countryCode\": \"IN\",\n \"postalCode\": \"B742DG\",\n \"addressLine1\": \"4 Mayland Drive Sutton Coldfield\",\n \"addressLine2\": \"West Midlands\",\n \"countryName\": \"GREAT BRITAIN (United Kingdom)\",\n \"state\": \"West midlands\",\n \"contactPhone\": \"07470021520\",\n \"customerName\": \"Gurjit Kaur\",\n \"email\": \"gurj180@gmail.com\"\n },\n \"taxAmount\": 0.0,\n \"orderDate\": \"2022-01-10 08:01:00\",\n \"items\": [\n {\n \"lineItemOrderStatus\": \"\",\n \"productAdditionalInfo\": {},\n \"quantity\": \"1\",\n \"shippingCharges\": 0.0,\n \"discount\": 4.0,\n \"mrp\": 2990.0,\n \"lineItemTotal\": 50.0,\n \"customerPrice\": 54.0,\n \"productName\": \"J0082226Y-SG71513-White A Line Front Slit Kurta Set In Cotton With Pink Printed Buttis And Geometric Motifs And Long Sleeveless Inner Online - Kalki Fashion\",\n \"itemID\": \"SG71513\",\n \"lineItemSequenceNumber\": \"2\",\n \"sku\": \"135PQ3H1YXT\",\n \"status\": \"CREATED\"\n }\n ],\n \"shipChargeAmount\": 0.0\n },\n \"channel_id\": \"2018\",\n \"order_id\": 44367438\n}","type":"text"}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"8. When all the orders on a particular CSV are created, update the job on platform as well with the below API. ","type":"text"}]},{"type":"paragraph","content":[{"text":"URL: ","type":"text"},{"text":"https://{{accountSlug}}.eshopbox.com/_ah/api/esb/v1/import-job/","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ffffff"}},{"type":"link","attrs":{"href":"https://workspace.eshopbox.com/_ah/api/esb/v1/_ah/api/esb/v1/import-job/2650"}}]},{"text":"","type":"text"}]},{"type":"paragraph","content":[{"text":"Headers: ","type":"text"}]},{"type":"table","attrs":{"layout":"default","localId":"8d9f090c-c69d-4fad-b6ac-fbf540482484"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Header","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Value","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Authorization","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Bearer ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"ProxyHost","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"","type":"text"}]}]}]}]},{"type":"paragraph","content":[{"text":"Request body: ","type":"text"}]},{"type":"codeBlock","content":[{"text":"{\n\"jobType\":\"order\",\n\"additionalDetails\":\"\",\n\"status\":\"1\",\n\"successCount\":10,\n\"failureCount\":3\n}","type":"text"}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":" ","type":"text"}]}],"version":1}

Browser not supported