Bestseller Log

Bestseller Log is used to check the payload of the SO creation and RSO creation of Bestseller orders. Bestseller Log can be checked by following the mentioned path.

Captive Panel Dashboard > System > Tools > Data Log

From the “Table”, select “Bestseller Log” in the drop down. 
1. Select “SOCREATE” in URL field, to check payload of orders created. If you need to see payload of any selected order, put that particular order number in “Filter Data” and select “Body” in “Filter in” field.

By filling in the details in mentioned field(s) and clicking on “Filter” button, it will filter out all the SOCREATE payload/logs against the selected order number.

The URL field in the log for SOCREATE would look like

https://bsixp1prd.bestseller.com/RESTAdapter/SOCREATE/

The Body field of the payload would look like this

{“CT_ERROR”:{“ITEM”:{“DOCUMENT”:[],”TYPE”:[],”MESSAGE”:[]}},”I_ADDRESS”:{“TITLE”:””,”NAME1″:”Hitesh Patel”,”STREET”:”F-104, Orchid blossom, Behind Stuti”,”HOUSENO”:” empress”,”DISTRICT”:”Surat”,”CITY”:”Surat”,”POSTAL_CODE”:”395009″,”COUNTRY”:”IN”,”REGION”:”06″,”MOBILE”:”7069018403″,”EMAIL”:”hp13_83@yahoo.in”},”I_CUSTOMER”:”ANS0000002″,”I_CUSTOMERORDER”:”JJ20411646″,”I_SALESORDER”:”ANS0074737″,”I_PAYER”:”0000202307″,”I_PAYMENT”:2,”I_REFERENCE”:”108710529241″,”I_BRAND”:”JJ”,”I_ORDDATE”:”20191122″,”ORDER_ITEMS_IN”:{“item”:[{“ORDER_MATNR”:”5713753575644″,”ORDER_QTY”:”1″,”ORDER_SITE”:”DC82″,”ORDER_ITEMNO”:”711707″,”ORDER_ZVKM”:1099,”ORDER_ZPRP”:1999,”ORDER_ZDSP”:”0″,”product_id”:”43608″,”ORDER_PRICE1″:0,”ORDER_PRICE2″:0}]}}

You can use https://jsonlint.com/ to see this payload in a readable manner.

Go to https://jsonlint.com/, paste this payload in the text edit section and click on “Validate JSON” button under it. The same payload would look like 

{

“CT_ERROR”: {

“ITEM”: {

“DOCUMENT”: [],

“TYPE”: [],

“MESSAGE”: []

}

},

“I_ADDRESS”: {

“TITLE”: “”,

“NAME1”: “Hitesh Patel”,

“STREET”: “F-104, Orchid blossom, Behind Stuti”,

“HOUSENO”: ” empress”,

“DISTRICT”: “Surat”,

“CITY”: “Surat”,

“POSTAL_CODE”: “395009”,

“COUNTRY”: “IN”,

“REGION”: “06”,

“MOBILE”: “7069018403”,

“EMAIL”: “hp13_83@yahoo.in”

},

“I_CUSTOMER”: “ANS0000002”,

“I_CUSTOMERORDER”: “JJ20411646”,

“I_SALESORDER”: “ANS0074737”,

“I_PAYER”: “0000202307”,

“I_PAYMENT”: 2,

“I_REFERENCE”: “108710529241”,

“I_BRAND”: “JJ”,

“I_ORDDATE”: “20191122”,

“ORDER_ITEMS_IN”: {

“item”: [{

“ORDER_MATNR”: “5713753575644”,

“ORDER_QTY”: “1”,

“ORDER_SITE”: “DC82”,

“ORDER_ITEMNO”: “711707”,

“ORDER_ZVKM”: 1099,

“ORDER_ZPRP”: 1999,

“ORDER_ZDSP”: “0”,

“product_id”: “43608”,

“ORDER_PRICE1”: 0,

“ORDER_PRICE2”: 0

}]

}

}

In the above payload example, you can see various details against the order like personal details of the customer including address, email ID and mobile number. These details are followed by ANS order ID, Bestseller Order ID, payment reference number, order details including the order date, order item, quantity, product ID, price of the product, etc.

The payload is pushed to SAP automatically when the cron on its scheduled time. 

Please note : Sometimes it is required to manually push the order to SAP, so what needs to be done is copy the payload of the SOCREATE which under “Body” section, and paste it in text edit section of “Postman App” under the collection of “Bestseller – Push API” (Select Order Push API > Body > Paste the payload > Click on Send

The Response may be different in the case of a Success or failure.

For a success response, it would look like –

{“body”:”{\”ZSD_SALESORDER_CREATE.Response\”:{\”CT_ERROR\”:{\”item\”:{\”DOCUMENT\”:\”JJ20411646\”,\”TYPE\”:\”S\”,\”MESSAGE\”:\”Omni Channel Sal.Ord ANS0074737 has been saved (delivery 60766780 created)\”}},\”E_CUSTOMER\”:\”\”,\”E_SALESORDER\”:\”Omni Channel Sal.Ord ANS0074737 has been saved (delivery 60766780 created)\”,\”ORDER_ITEMS_IN\”:{\”item\”:{\”ORDER_MATNR\”:5713753575644,\”ORDER_QTY\”:\”1.000\”,\”ORDER_SITE\”:\”DC82\”,\”ORDER_REFSITE\”:\”\”,\”ORDER_ITEMNO\”:711707,\”ORDER_ZVKM\”:\”1099.000000000\”,\”ORDER_ZPRP\”:\”1999.000000000\”,\”ORDER_ZDSP\”:0,\”ORDER_PRICE1\”:0,\”ORDER_PRICE2\”:0}}}}”,”error”:””,”http_code”:200}

For a failure response, it would look like –

{“body”:”{\”MT_REST_Pretr_SO_CREATE_FAULT_SYNC\”:{\”standard\”:{\”faultText\”:\”SO_CREATION_FAILED\”,\”faultDetail\”:{\”text\”:\”Missing Payment Gateway Reference No. \”}}}}”,”error”:””,”http_code”:500}

In simple words, if the response has > http_code”:200, it means the SOCREATE was successful or the order was pushed successfully in the SAP. If the response has > http_code”:500, it means the SOCREATE has failed or the order has not been pushed in the SAP because of some error (which is mentioned in the response”

Select “RSOCREATE” in URL field, to check payload of orders for which return has been placed by the customer. If you need to see payload of any selected order, put that particular order number in “Filter Data” and select “Body” in “Filter in” field.

By filling in the details in mentioned field(s) and clicking on “Filter” button, it will filter out all the RSOCREATE payload/logs against the selected order number.
The URL field in the log for RSOCREATE would look like –

The Body field of the payload would look like this –

{“RETURN”:{“ITEM”:{“DOCUMENT”:[],”TYPE”:[],”MESSAGE”:[]}},”BANK_DETAILS”:{“BANK_NAME”:””,”BACK_ACC_NO”:””,”ACC_HOLDER_NAME”:””,”BRANCH_NAME”:””,”IFSC_CODE”:””},”PICKUP_ADDRESS”:{“FIRST_NAME”:”tejal”,”LAST_NAME”:”majithiya”,”TELEPHONE”:”9879444747″,”STREET”:”VISHAKHA HOUSE, ASHIRWAD PARAS CORP”,”HOUSENO”:”ORATE HOUSE NO 2 , NR RIVIERA ELEGA”,”DISTRICT”:”AHMEDABAD”,”POSTAL_CODE”:”380015″,”CITY”:”AHMEDABAD”,”REGION”:”06″,”COUNTRY”:”IN”},”SO_ITEMS”:{“item”:[{“SO_NO”:”ONLY403985″,”ORDER_ITEMNO”:”697412″,”REASON_CODE”:”15″}]},”I_RETURNPAYER”:”0000202307″,”I_RETORDDATE”:”20191120″}

You can use https://jsonlint.com/ to see this payload in a readable manner.

Go to https://jsonlint.com/, paste this payload in the text edit section and click on “Validate JSON” button under it. The same payload would look like 

{

“RETURN”: {

“ITEM”: {

“DOCUMENT”: [],

“TYPE”: [],

“MESSAGE”: []

}

},

“BANK_DETAILS”: {

“BANK_NAME”: “”,

“BACK_ACC_NO”: “”,

“ACC_HOLDER_NAME”: “”,

“BRANCH_NAME”: “”,

“IFSC_CODE”: “”

},

“PICKUP_ADDRESS”: {

“FIRST_NAME”: “tejal”,

“LAST_NAME”: “majithiya”,

“TELEPHONE”: “9879444747”,

“STREET”: “VISHAKHA HOUSE, ASHIRWAD PARAS CORP”,

“HOUSENO”: “ORATE HOUSE NO 2 , NR RIVIERA ELEGA”,

“DISTRICT”: “AHMEDABAD”,

“POSTAL_CODE”: “380015”,

“CITY”: “AHMEDABAD”,

“REGION”: “06”,

“COUNTRY”: “IN”

},

“SO_ITEMS”: {

“item”: [{

“SO_NO”: “ONLY403985”,

“ORDER_ITEMNO”: “697412”,

“REASON_CODE”: “15”

}]

},

“I_RETURNPAYER”: “0000202307”,

“I_RETORDDATE”: “20191120”

}

In the above payload example, you can see various details against the order like personal details of the customer including pickup address, mobile number. These details are followed by Bestseller Order ID, order details including the order item(s) (for which the return has been placed by the customer), return order date. For prepaid orders, the bank details are not mentioned in the payload, but in case of COD, the bank details are also provided in the payload.

The payload is pushed to SAP automatically when the cron on its scheduled time.

Just like in case of SOCREATE, it is required to manually push the return in the SAP. The procedure is same. Only change is the Payload of RSOCREATE has to pasted in the different collection in this case which is Return API (Go to “Bestseller – Push API”, Select Return API > Body > Paste the payload > Click on Send)

  • The Response may be different in the case of a Success or failure.

In case of Successful push of RSOCREATE, the response would look like –

{“body”:”{\”ZSD_SALESORDER_CANCEL_RETURN.Response\”:{\”RETURN\”:{\”item\”:[{\”DOCUMENT\”:\”ANS0060517\”,\”TYPE\”:\”S\”,\”MESSAGE\”:\”Returns omnichl Sale 60739571 has been saved (delivery 84124669 created)\”},{\”DOCUMENT\”:\”ANS0060517\”,\”TYPE\”:\”S\”,\”MESSAGE\”:\”Returns omnichl Sale 60739572 has been saved (delivery 84124670 created)\”}]},\”SO_ITEMS\”:{\”item\”:[{\”SO_NO\”:\”VM20389733\”,\”ORDER_ITEMNO\”:673179,\”REASON_CODE\”:15},{\”SO_NO\”:\”VM20389733\”,\”ORDER_ITEMNO\”:673180,\”REASON_CODE\”:15},{\”SO_NO\”:\”VM20389733\”,\”ORDER_ITEMNO\”:673181,\”REASON_CODE\”:15}]}}}”,”error”:””,”http_code”:200}