The following section describes how to configure Image Mover. Image Mover pushes up item images from the client's server to their e-commerce site.

Prerequistes
CP Extender folder on client server
CP SQL Database name
Microsoft SQL admin credentials(username and password) with CP database access
BigCommerce or Magento API info(URL, BC Store Hash/Client ID/Token or MG Store View/Token.)

 First you need to configure Settings on the CPExtender web config file.

1. Right-click RR_CPExtensionService.exe config file.

2. Open file  with Notepad ++, or Notepad.

3. Set "CP_IMAGE_SERVICE_ENABLED" value to true.
4. Paste in CP SQL Database name for "CP_IMAGE_CP_ALIAS" value.
5. Paste in CP Item Images folder location for CP_IMAGE_ITEM_DIRECTORY value.
6. Paste in CP Customer Images folder location for CP_IMAGE_CUSTOMER_DIRECTORY value.
  

cadd 
«add 
key= 
SERVICE ENABtXD " 
cusra«R DI 
INTERVAL 
PARrnw• / > 
(x86) / > 
" (x86)


7. Type in MG(Magento) or BC(Bigcommerce) for "CP_IMAGE_POSTSYSTEM" value.
  

INAGE UPLOAD INTERVAL" / >


8. Type Magento site URL or https://api.bigcommerce.com/stores/{{StoreHash}} for CP_IMAGE_POSTURL).
9. If configuring BigCommerce, paste client's BC store hash for "CP_IMAGE_BC_StoreHash" value. 

10. If configuring BigCommerce, paste client's BC client ID for "CP_IMAGE_BC_ClientID" value.

11. If configuring BigCommerce, paste client's BC token for "CP_IMAGE_BC_AuthToken" value.
12. If configuring Magento, Type in client's MG store view for"CP_IMAGE_MG_Storeview" value.
13. If configuring Magento, Type in client's MG token for "CP_IMAGE_MG_BearerToken" value.

  

- Acceptable: MG, 
«add 
POSNRL" 
BC / > 
BC / > 
keFCP / >

 


11. Save and close file.


Next,  you need run The "ImageMoverTableCreationQuery" file on SQL server.


1. Paste the following link into a web browser (https://drive.google.com/file/d/1W9Js4F_QS7x2rJYEn9uUGhs8H-kW8lJx/view?usp=sharing).
2. Select "Download" button.
  


3. Navigate to Windows search box.

4. Search studio.
5. Select "Microsoft SQL Server Management Studio.
  


6. Log in with admin creditentals(username and password).
7. Navigate to CP database(example TestGolf).
8. Open the "Tables Folder" and highlight one of the .dbo tables.
  

' 01 ' 段 43U0 1-0 34 。 名 3 一 
00U ' 」 03d | 15nH340 名 3 一 
1 0 丨 n 」 ' 340qP 一 
5031 ) | 15n 34d 
00U ' 931 34 。 囓 
110N ' 15n 3 0 
OS - 15n 34 。 
30M 一 40 名 3 一 
0N1 鬥 40 3 一 
」 ' 3 09P 
90


9. Select the "File" tab.
10. Navigate to "Open".
11. Select "File".
  

Microsoft Server Studio (Admetistrator) 
View 
Obj 
Explorer 
Close Solution 
Selected Itenu 
Save Selected Items 
Save A" 
Page Setup... 
pnnt... 
Recent 
Recent P and Solutions 
Help 
• I name 
Ctrl— S 
Ctrl* Shift* S 
Ctrl. p 
P eject-ISO 
Merge "tended . 
Merge Audit Files... 
file with New Connection— 
File 
P o' icy 
ctrl.shft.o 
Ctrl* Shift* O 
Ctrl. 0


12. Navigate to and select  the ImageMoverTableCreationQuery file.

13. Click "Open".
  

Орет Fde 
Т ТКВ РС 
• Г4«м fc[d« 
Р'стшн 
Л 2021-11-22 иск 
ОаИср 
Оосителв 
S-e•rth 
оттр 
-LM.zip 
О modf.ed 
дм 
2,54 ем 
дм 
943 дм 
лудо,'2021 ем 
7:53 дм 
7'2,'2D21 
4: 14 рм 
р 
о 
туре 
С • эго р 
дрок 
Арр'.с 
Арр]'с 
Сот р 
Appli( 
%cro•_ 
Appht 
Apphc 
Д рр]'к

 

14. Select Execute.

15. You should see the creation of the Image Mover SQL tables.
  

- CPSQLsvæpARTMAN SQL serve, 
File Quew Pr*t TOO'S WmdOW 
Object 
Connect • 
I mageMover (62)) 
- APP IWEXING FILTER 
NEED cp TABLE 
UPDATI% FIELDS '"WALLY. 
NEEDED IF cusT04ER uS ING 
p mab"ty 
rity 
PARTMAN_ 
PARTMAN_3_ 14_2018 
Sh pWorks 
TestGoH 
u rity 
IF EXISTS(SELECT • „s.tables *ERE 
DROP TABLE 
SET on 
SET UTEO_IOEKTIFIER 
CREATE TABLE . 
tKEY_1D) NOT 
[ITEM_FILTERI WLL, 
tT_DT] NULL, 
[T_DTI WLL, 
(T _OTJ 'JULL, 
(T_DT] WLL, 
[CuST_FILTER1 NULL, 
[T_DT] WLL, 
[T _OTI 
chen_id) LIKE 
• Al-O nae 
Connected Il 
cpsQLSVR LIGHTHOUSE\Administr.t,.. 
PART MAN 
o rows