User Tools

Site Tools


check_details_sent_to_magento

Check details sent to Magento

Cards Direct have a number of web product category. First thing to check is that it is actually a web_product

SELECT web_product, * FROM vw_Product1 WHERE barcode = '5053349002438'

SELECT * FROM websites.vw_WebProductCategory WHERE product = 50758
EXEC traxs_depends 'websites.web_product_category'

We can find the web processes which reference 'product' using:

webhelp product

We can find what the request and response was using the following:

SELECT * FROM websites.vw_WebsiteInterfaceProducts_ProductListing WHERE product = 50758
SELECT request FROM websites.rest_session WHERE request LIKE '%5053349002438%' AND date_time > '2021-06-22 11:35:07.997'
SELECT response FROM websites.rest_session WHERE request LIKE '%5053349002438%' AND date_time > '2021-06-22 11:35:07.997'

The response is I JSON format which can be difficult to read. Therefore an editor can be used however must be careful not to use PID:

https://jsoneditoronline.org/
check_details_sent_to_magento.txt · Last modified: 2021/06/23 07:39 by 212.42.166.188