This project entails extending the functionality and user interface of an existing prototype of a tool that takes data from Lightspeed POS and Lightspeed eCommerce and posts data to Reverb.com. Programming language is not specifically important, but database should be SQL Server.
Project must be completed not later than 8 weeks, including debugging. You will be expected to correct bugs that appear after project is completed. It is very likely that the project will be expanded in the near future to include additional functionality.
1) Payment gateway to charge customers 1-time setup fee, flat monthly fee and a fee based on percentage of sales on [login to view URL]
a. Monitor non-payment. Delete account/Freeze account after x days of non-payment. Do not post items or pull items when payment is not current.
2) API Issues:
a. Reverb Authentication
b. Lightspeed authentication
i. Lightspeed authentication has 2 different components, Retail POS and eCom
c. Retrieve any existing Reverb listings when a new customer signs-up. Write data to existing Reverb table. User name must be respected.
d. Retrieve data from Retail POS and eCom and write to existing SQL tables.
i. Data must be maintained by user
e. Webhooks must be used to monitor eCom/POS to monitor updates, additions or deletions of existing product records. Changes must be updated to SQL table
f. Upload/edit/delete products to Reverb, using existing SQL table structure.
g. Syncing tool to make sure Lightspeed/Reverb system stays in sync.
h. Tie in between Lightspeed POS/eCom and Reverb will be SKU number.
i. Upload orders from Reverb to Lightspeed POS
3) User Interfaces required (including appropriate support database tables):
a. CSS-based only
b. User sign-in/New User Registration
c. Forgotten Password/Reset Password Functionality
d. Category retrieval from eCom with mapping functionality to [login to view URL] categories
i. Categories must be able to be synced to both systems so changes in category structure can be monitored
e. Reverb Shipping Profile retrieval with ability to assign to Reverb Category at user level
f. Reverb order list dashboard with automatic and/or manual order uploading to Lightspeed POS
g. Interface showing items in Lightspeed POS/eCom that is sortable/filterable by field so that missing data field items can be determined, edited and uploaded back to POS/eCom as necessary
h. Admin Panel with customer control/customer settings
4) Custom fields are required in Lightspeed Retail POS to make this project work. Create and populate custom fields in Lightspeed automatically upon new user sign-up (if possible)
5) Database should be stable and in cloud with data access via local SQL Server installation. Workable data table structure for Lightspeed POS/eCom and Reverb already exist and can be provided.