Customization to JROX E-Commerce Management(JEM) Shopping Cart Script
- or -
Post a project like this$500
- Posted:
- Proposals: 1
- Remote
- #1018669
- Expired
Description
Experience Level: Expert
PHASE 1 ==> IMPORT & SALES OF E-PINS
Project Phase Description
IMPORT OF E-PINS
Create an import script (on website) to "power" the import/upload of airtime vouchers PIN Nos. to an Import Table (created and placed on the admin interface), via an import module named "IMPORT AIRTIME VOUCHERS", and to the main database which will feed a secondary database.
The Import Table should contain the following details on each row:
1. Row No. (to be automatically populated on admin uploading purchase csv file)
2. Purchase Date (to be automatically populated on admin uploading purchase csv file)
3. Invoice No. (to be automatically populated by the correct details on member/customer purchase/payment)
4. Invoice Date (to be automatically populated by the correct details on member/customer purchase/payment)
5. Product Type (to be automatically populated on admin uploading purchase csv file)
6. PIN No. (to be automatically populated on admin uploading purchase csv file)
7. Expired ( to be populated by a number-1 on sale/payment by member/customer)
8. Don't Display (Not to be displayed on admin uploading csv, inserting Number- 1 in column)
9. Delete ( expired/used airtime vouchers to be deleted from database and to also be simultaneously deleted from member/customer account, on admin uploading csv, inserting a number- 1)
ONLY Nos. 1,5,6 should be compulsory filled for admin import of csv to succeed.
SALES OF E-PINS
An "AIRTIME VOUCHERS PIN Nos." folder should be created in members'/customers' account, with an icon of the folder labelled appropriately and placed on the members'/customers' dashboard, which when clicked, should reveal the following details on each row:
1. Invoice No.
2. Invoice Date
3. Product Type
4. PIN No.
AUTOMATION of delivery of airtime vouchers PIN Nos. to the folder in the members' account on site, reflecting in "Import Table" and database as applicable, on member making payment.
PHASE 2 ==> STOCK RECORD FOR E-PINS
Project Phase Description:
Two(2) airtime vouchers PIN Nos. Stock Balances Tables - each stock table for each database, should also be created/placed in the admin interface. Each of the two(2)stock tables should contain the following details on each row:
1. Product Type
2. Quantity
3. Sales Price (to be inserted by admin)
4. Sales Value (Quantity x Sales Price - automatically generated on insertion of sales price by admin)
TOTAL Quantity and TOTAL Sales Value is to be automatically generated for columns 2 and 4 i.e. Quantity and Sales Value
Automation of transfer of ONLY ONE Product Type Of Airtime Vouchers details AT A TIME, from the main database to the secondary database, as and when desired by admin.
A table to be created for this purpose should contain the following details:
1. Row Nos. in batches (to tally with row nos. on Import Table)
2. Product Type (to be automatically populated on inserting row nos.)
3. Quantity (to be automatically populated on inserting row nos.)
4. Sales Price (to be inserted by admin)
5. Sales Value (to be automatically generated on insertion of sales price by admin)
TOTAL Quantity and TOTAL Sales Value is to be automatically generated for columns 3 and 5 i.e. Quantity and Sales Value.
ONLY the secondary database is to directly feed the members' accounts i.e. Members' accounts should never be able to drawdown from main database.
PHASE 3 ==> SHOPPING CART CUSTOMIZATION & EXPORT SCRIPT CREATION
Project Phase Description:
SHOPPING CART CUSTOMIZATION
Programming to ensure "Product Type" in shopping cart is "tripped off" i.e. made non-available, in situation of airtime voucher pin nos. non-availability in Secondary Database and 2nd Stock Table.
EXPORT SCRIPT
Create an export script (on website) to "power" the export/download of airtime vouchers PIN Nos. through a suitable Export Table (created and placed on the admin interface) using an export module named "EXPORT AIRTIME VOUCHERS", to occasionally export the airtime vouchers details in database (in batches), to Excel/CSV. The export table should contain the following, at a minimum:
1. Row Nos. in batches (to tally with row nos. on import table)
NOTES TO PROJECT IS HEREBY ATTACHED
Project Phase Description
IMPORT OF E-PINS
Create an import script (on website) to "power" the import/upload of airtime vouchers PIN Nos. to an Import Table (created and placed on the admin interface), via an import module named "IMPORT AIRTIME VOUCHERS", and to the main database which will feed a secondary database.
The Import Table should contain the following details on each row:
1. Row No. (to be automatically populated on admin uploading purchase csv file)
2. Purchase Date (to be automatically populated on admin uploading purchase csv file)
3. Invoice No. (to be automatically populated by the correct details on member/customer purchase/payment)
4. Invoice Date (to be automatically populated by the correct details on member/customer purchase/payment)
5. Product Type (to be automatically populated on admin uploading purchase csv file)
6. PIN No. (to be automatically populated on admin uploading purchase csv file)
7. Expired ( to be populated by a number-1 on sale/payment by member/customer)
8. Don't Display (Not to be displayed on admin uploading csv, inserting Number- 1 in column)
9. Delete ( expired/used airtime vouchers to be deleted from database and to also be simultaneously deleted from member/customer account, on admin uploading csv, inserting a number- 1)
ONLY Nos. 1,5,6 should be compulsory filled for admin import of csv to succeed.
SALES OF E-PINS
An "AIRTIME VOUCHERS PIN Nos." folder should be created in members'/customers' account, with an icon of the folder labelled appropriately and placed on the members'/customers' dashboard, which when clicked, should reveal the following details on each row:
1. Invoice No.
2. Invoice Date
3. Product Type
4. PIN No.
AUTOMATION of delivery of airtime vouchers PIN Nos. to the folder in the members' account on site, reflecting in "Import Table" and database as applicable, on member making payment.
PHASE 2 ==> STOCK RECORD FOR E-PINS
Project Phase Description:
Two(2) airtime vouchers PIN Nos. Stock Balances Tables - each stock table for each database, should also be created/placed in the admin interface. Each of the two(2)stock tables should contain the following details on each row:
1. Product Type
2. Quantity
3. Sales Price (to be inserted by admin)
4. Sales Value (Quantity x Sales Price - automatically generated on insertion of sales price by admin)
TOTAL Quantity and TOTAL Sales Value is to be automatically generated for columns 2 and 4 i.e. Quantity and Sales Value
Automation of transfer of ONLY ONE Product Type Of Airtime Vouchers details AT A TIME, from the main database to the secondary database, as and when desired by admin.
A table to be created for this purpose should contain the following details:
1. Row Nos. in batches (to tally with row nos. on Import Table)
2. Product Type (to be automatically populated on inserting row nos.)
3. Quantity (to be automatically populated on inserting row nos.)
4. Sales Price (to be inserted by admin)
5. Sales Value (to be automatically generated on insertion of sales price by admin)
TOTAL Quantity and TOTAL Sales Value is to be automatically generated for columns 3 and 5 i.e. Quantity and Sales Value.
ONLY the secondary database is to directly feed the members' accounts i.e. Members' accounts should never be able to drawdown from main database.
PHASE 3 ==> SHOPPING CART CUSTOMIZATION & EXPORT SCRIPT CREATION
Project Phase Description:
SHOPPING CART CUSTOMIZATION
Programming to ensure "Product Type" in shopping cart is "tripped off" i.e. made non-available, in situation of airtime voucher pin nos. non-availability in Secondary Database and 2nd Stock Table.
EXPORT SCRIPT
Create an export script (on website) to "power" the export/download of airtime vouchers PIN Nos. through a suitable Export Table (created and placed on the admin interface) using an export module named "EXPORT AIRTIME VOUCHERS", to occasionally export the airtime vouchers details in database (in batches), to Excel/CSV. The export table should contain the following, at a minimum:
1. Row Nos. in batches (to tally with row nos. on import table)
NOTES TO PROJECT IS HEREBY ATTACHED
Oladele O.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
4 May 2024
Nigeria
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies