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}

Bestseller – Line Item Return Raise

There may be scenarios when the client ask to raise return for specific line item(s) in the order, because return option is not available to the customer in their account as some other line item has been cancelled by brand/customer has already returned one of the line item/or some other reasons. 

Following steps are to be followed in such cases:

  1. Go the bestseller admin panel.

Dashboard > Sales > Orders > Fill Order ID or Partner Order ID > Click on Filter button

Click on “View” button next to it

2. After click on “View” button, the screen would look like as the below image

In the above example, one of the line items has already been status as “Refunded”, hence the customer is not able to see return option against the rest of the line items.

There can be following statuses also:

  • RETURN_AWAITING
  • RETURN_APPROVED
  • CANCELLED
  • RETAWB
  • CREDIT_MEMO
  • ORDER_CLOSED

3. To raise return for line item(s) in this case, the status of all the line item(s) has to be changed to “Item Delivered” temporarily.

Click on the status against line item(s), a new window will open.

Select “Item Delivered” from the drop down.

Click on “Save” Button after changing the status

4. Go to the customer’s account and now return option would be available against the line items.

Now, the return option is available, the return can be placed by clicking on “Return” against the line item(s). Incase, it is prepaid order, return can be raised now and then. While for COD orders, customer’s bank details would be required.

5. After placing the return, change back the status of line items which were temporarily changed to “Item delivered” to their original status.