Before beginning the SimplePhoto Lab Bridge setup process, please setup an FTP site at your lab and send the FTP server address and login information to tech@simplephoto.com. SimplePhoto will use this FTP site to send order data files to your lab. The FTP folder will need to be accessible across your network from the machine running the Lab Bridge Order Import program.
1. Run the Setup_SPKLab2.msi installation program
2. Copy the files in the "UpdatedFiles-OrderImport" folder into the directory where you installed the program, such as C:\Program Files\SimplePhoto\SPKLab2 . When you are prompted, allow the existing files to be overwritten.
3. Setup and test the connection to the DP2 Database
Open the "SPLab2" program in the new "SimplePhoto" program group. Click on the "Settings" icon, then click on the "Database Connection String" button in the lower right hand corner. In the "DP2 Connection String" field... type the following (replacing the DP2DatabaseServerName and DP2DatabasePassword with the appropriate values):
Data Source=DP2DatabaseServerName;Initial Catalog=DP2;User Id=sa;Password=DP2DatabasePassword
Click the "Test Connection" button. If you see the message "Test database connection successful!", proceed to the next step. If you see an error message or the "Unable to connect to database" message, please review the connection string and try again. It may be helpful to view the database connection information for your DP2 workstation to obtain the necessary database connection string.
4. Configure the SimplePhoto Lab Bridge Order Import program
-----------------------------------------------------
Open the "SPLab2" program in the new "SimplePhoto" program group. Click on the "Settings" icon.
Here are explanations of the most important settings:
5. Setup Lab Products
---------------------------
Login to SimplePhoto with your lab login information. Click the "Products" tab. Click the "Add Product Group" button. Type a name such as "DP2 Test Products" and click the "Add" button.
Add a couple test products individually or use one of the CSV data import options at the bottom of the Lab Products screen. The Product Code field should have the DP2 Layout ID. For more details on adding lab products, visit: http://labhelp.digitaleventpics.com/lab-products/create-lab-products
6. Create a Retail Price list using the test lab products
---------------------------
On the page that shows the products inside the "DP2 Test Products" group, click the "Create Template" button below the list of products. Click the "Edit" button next to the newly created Retail Price List Template. Scroll to the bottom and click the "Published" checkbox and then click the "Update" button.
Login to the appropriate photographer account. Click the "Photographers" link in the navigation links at the top and then click the "Login" button next to the photographer account where the test DP2 Bridge upload was sent.
Click on the "Photographer Information" link on the SimplePhoto Dashboard. Scroll down to the "Product Groups Authority" section and either select the "All" option or select the "Test DP2 Products" options. Click the "Update" button. This will give the photographer account the authority to use the lab product group we just created.
Click the "Price Lists" link in the top navigation links. Scroll to the very bottom where you see the "Create new price list from Lab Template" section. Choose the "Test DP2 Products - Retail" option from the menu and click the "Create Price List" button. Rename the price list if desired and click the "Create Price List" button. This will copy the lab-level price list template into the photographer account.
Click the "Galleries" tab in the navigation links at the top. Find the job name uploaded earlier and click the adjacent "Folder Control Panel" or "Group Control Panel" button. Click the "Gallery Control Panel" button next to a gallery. Scroll to the "Price List" setting and change the price list to "DP2 Test Products - Retail". Scroll to the bottom and click the "Update" button. This associated the photographer's new price list with a gallery we uploaded using the DP2 Bridge.
7. Place a test order. On the "Gallery Control Panel", scroll to the bottom and click the "Cash Sale" button. A new web browser will open with the SimplePhoto gallery and shopping cart. Select one or two of each of the test products and complete the order. If SimplePhoto has finished configuring the FTP information provided by your lab, SimplePhoto should send order data to your lab as soon as the "Confirm Order" button is clicked on the final shopping screen.
8. Use the DP2 Bridge order Import program to import the test order. Open the SimplePhoto Lab Bridge Order Import program and click the "Start" button. You should see in the log that the test order was imported properly.
9. Verify that the test order was created properly in DP2 The DP2 Order ID generated by SimplePhoto will begin with an "S" and the rest of the DP2 Order Id will be the SimplePhoto Order ID.
Description of additional program settings
-------------------------------------------------------
DP2 Bridge Order Import program
These settings are typically left to their default values:
* "DP2 Images Folder" - not in use at this time, but must be defined. ex. C:\SPLabBridge\temp
* "Processed Orders Folder" - used to store processed orders. Useful for debugging purposes during testing. ex. C:\SPLabBridge\ProcessedOrders
* "Exception Orders Folder" - used to store orders that were not processed due to an error. Useful for troubleshooting problems. ex. C:\SPLabBridge\OrderErrors
* "Log Files Folder" - Used to store log files generated by the program. Useful for debugging purposes during testing. ex. C:\SPLabBridge\OrderImportLogs
* "Other Vendor Files Folder" - not in use at this time, but must be defined. ex. C:\SPLabBridge\temp
* "Polling Interval" - the number of seconds the program will wait to look for new orders in the "Received Orders Folder".
Tip for upgrading to a new version
Until the SimplePhoto Lab Bridge has automatic update capabilities, the program will lose all settings each time the program is updated.
To workaround this issue, you can copy the file named "user.config" located in the folder:
C:\Users\(YourUsername)\AppData\Local\SPKLab2\SPKLab2.exe_Url_(random characters)\1.0.x.0\ <- the folder name with the old version number
and paste this file into the new version folder:
C:\Users\(YourUsername)\AppData\Local\SPKLab2\SPKLab2.exe_Url_(random characters)\1.0.x.0\ <- the folder name with the new version number