This section will cover how push test product data to the Client's ecommerce site.

 

Prerequsites 

1. List of test products from client (3 to 5 items for product category)

2. SQL server credentials (username and password)

 

First, we to verify webhooks are syncing to SQL server.

  

1. Open “Microsoft SQL Server Management Studio".

2. Point Object Explorer to "CounterPoint" Database.

3. Create a new query.

4. In new query, type in Select * From USR_CPHIVE_SUBSCRIPTION.

5. Verify if "product/created" , "product/updated" , "product/variant/inventory/created", and product/variant/inventory/updated is marked as "Y".

 

 

SQL Qu"3.sqI• (62)) X • Ser ipt 'SELECT TOP f løw [SCCPEI FRO* _ (dbol . suescR8E0 17 18 19 21 27 28 LSI 0T 2021-070 202108-02155757577 2021-0802 2021070 154547343 2021070 154547 2021070 IS'S47S30 2021-0701 NULL NULL NULL NULL EXISTS (SELECT TOP WHERE N_ITEN Is ECOMM ITEM. Y €xsrs TOP WHERE EXISTS (SELECT TOP WHERE N_ITEN nan Gn•nv j m-mm

 

 

Next, we need to verify product data is pushing through from "Counterpoint".

 

1. Log in into SQL Server Management Studio.

2. Navigate to Object Explorer. (Note: if "Object Explorer is not open, User will need to connect to it)

3. Select "New Query" from taskbar.

4. Type in UPDATE IM_ITEM SET ITEM_NO = ITEM_NO where ITEM_NO ='INSERT ITEM NUMBER HERE'.

5. Type in SELECT * FROM USR_CPHIVE_QUEUE.

6. Select "Execute.

 

SELECT ' IJSR CPHIVE u

 

7. Repeat Steps 1-6 for the rest of the test products.