This section will cover how push product data to the Client's ecommerce site as client nears go live date.

 

1. Log in into SQL Server Management Studio.

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

3. Nav to and select "dbo.USR_CPHIVE_SUBSCRIPTION

4. Right-click "Edit Top 200 Rows".

 

Management 丨 P053 e , P•pbatim S* 10b d 圞 dbo,USR_APLL dba - L E .1 dbo.USER_PuåNGE 冖 「 dboUSER_RANGE dba USER_ 圞 0 一 爿 . RAT 圞 孚 0 - , A _CO OL 。 - US . , AS NT 。 - $ NTO_PROO' T_LI' ㄆ dba - - ER. ~ $ NTO , CO dbo•L5ER.MAGENTO_ATTR18UTE dbo,USER_lTEM ~ 20 T - | MS dba 一 」 M 」 MPORT 圞 dba 一 」 M CONVERSION dbo.LßER-REN1 dboUSER_RENT dbo.USER_MA6ENTO_DEL_lM_ITEM dba.USER_MA6ENTO ATTRIBUTE_OPTION d&aUSER, 」 TEM_REPLACEMENT m 。 Op · A or Ed * TOP28 「 0 , , 102T4 一 ; PM

 

8. Add "AND IM_ITEM.PROF_NO_# = #" to product/created" and "product/updated "  to FILTER Fields. 

9. Click "Enter" key.

10. Product Filters should now have IM_ITEM.IS_ECOMM_ITEM = '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


11. Create a new Query.
 12. Type Select * From IM_ITEM where IS_ECCOM_ITEM = 'Y'.

13. Select Execute.
14. Look for a Column name that's not being currently used to fill for a SQL Job (Example:Prof_No_4).
  

• Ix where Mesa*' NULL PROF_Q2 NULL PROF-NO-3 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL ROFJ0_5 GRID-DI NULL 1.1800 NULL

 

15. Navigate to SQL Server Agent and click + button.

16. Navigate to Jobs and click + Button.
17. Right Click jobs area and select New Job"
 .

Database Snapshots cPM.gentoM2 cppractice CPS-stemCPSQL_1 CSSer,icesM2 Spruce Database Diagrams Tables Synonyms Programmability Service Storage Security ZZZ01dSpruceRemote Security Server Objects Replication Management SQL Serve ent a ZJo Update customers Job Activiw Alerts Operators Proxies Error Logs SQLQuery2sq1- cp. E UPDATE IY_ITEY SELECT - UPDATE lop WHERE IS Ecct-2-! SELECT PROF CC SELECT • FROM New Jobm Start at Step„ . Strp Job Script Job Enable Start P owerSheII

 

18. Type in Job name (Example: Product Sync).

19: Select Steps.

SYT

 

14. Select New.

15. Type in Step name. (Example: Sync)

16. Select Counterpoint Database from Database Dropdown

17. Type in Query for job. (Example UPDATE TOP (60) IM_ITEM SET PROF_COD_4 = 4 WHERE IS_ECOMM_ITEM = 'Y' AND COALESCE(PROF_COD_4, 9) <> 4)

18. Click Ok.
  

Trmsa*-nL (T-m aeute succesfulty. TOPt60) IM_ITEM SET WHERE IS_ECOMI I CPSERVER(10.50SP3) I sa (71) |

 

19. Select "Schedules".
20. Select New".

21. Type in name (Example: Recur).

22. Change "Frequency" to "Daily".

23.  Change " Daily Frequency" to “Occurs every 10 mins".
24. Check "Enabled" box next to "Schedule type".

25. Click Ok.


0 「 H HIST o.AR_FC OAR C OAR-C oAR-CT •AR-CA 0 - VEN O.AI_V F 、 NewJob 5 du R%u•evey Queryexecuted successfully, & 、 on 2L11- 〔 21 , 1 RECUR 一 二 1 5 3 … 32 PM 11 $ P 亠 202 一 二 1 4 丨 0 1

 

26. Click Ok again.
27. Highlight Job.

28. Right-click and select "Start Job at Step" to verify query works.

 

Synonyms Programmabilfy 'J Service CO Storage Security ZZZOIdSpruceRernote Security Server Objects Replication Management SQL Agent S Jobs 3 IPAAS_PRODUCT syspolicy_pu rge_ Update custcmers Job Activity Monitor Alerts Operators Proxies Error Logs New Job at Job *ript Job as View Hstory Enable Start P owerSheII PROF-DAT-5 successfully, NULL Imo 1 uoo NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL

 

If query failed…or recurrence is not working properly, the settings were not implemented correctly. 

Please check your work.