Find Jobs
Hire Freelancers

vtiger oscommerce integration

min $3000 USD

In Progress
Posted almost 16 years ago

min $3000 USD

Paid on delivery
I. Project Goal - To keep track of customer relations, including all emails sent to & from customers, all orders placed by customer, all support tickets opened by customer, all returns created by customer. 1) Linking accounts – All accounts should be linked from vtiger to oscommerce by using the same database table. All accounts that exist in OSC should exist in vtiger, including billing & shipping address. 2) Orders – All orders by a customer (account) should be viewable when viewing a customers account. The required info should include order date, order product_name, order quantity, order product_vpn (Vendor part number), order price, order shipping method, order tracking number link (editable), a button to edit_orders, payment method. 3) New Customer – When creating an account in vtiger, an account should be created in oscommerce, because they should be using the same table. 4. New Order – We take phone orders. After creating a new customer, we create a new order, which uses a version of edit_orders.php. We then charge the order through [login to view URL] (the payment button). We need to be able to create an order & charge it, after creating a new customer, or using an existing customer. 5) email – all emails should be pulled from inbox and sent items, and posted to customers account inside vtiger. We will need mailbox support for our general email deliver () and individual users. All email correspondence should be recorded from any user on our mail server (exchange with IMAP support), and appended to the customers account in vtiger 6) all support tickets should be linked to vtiger account. When viewing a customers account, we should have click access to the support ticket linked to that customer account. Also, When a new ticket is present, staff should be able to respond to, and close tickets through vtiger either by integrating in vtigers current support ticket system, or simple referring to the existing support system. 7) customer returns section – All returns should be viewable when viewing on a customers account in vtiger. Also, staff will need access modify the returns through current osc admin functionality. 8. Invoicing – Using the current vtiger invoicing, we need to be able to generate a receipt/invoice for a customers order and email it to them. 9. Products – no product functionality is needed except for reports 10. Reports – I should be the only on with access to this. It may be better for me to work on this functionality through the current osc admin. I will need a link, visible only to me, for reporting features currently in OSC’s admin. Here are the reports that will need to be created. a) Orders by VPN, per month, year b) Order totals to vendor (cost per vendor (located in the products table) plus shipping cost specified by vendor in their admin). These two should be totaled to create a custom report, daily & weekly. 11. New Orders – we will need to view the current orders.php. This will allow us to view new orders, and assign them through [login to view URL] 12. auctionblox – We simply need a link to the current auctionblox functionality within OSC 13. Live chat functionality – We need a toggle switch (exists in the current admin) to turn off/on live chat. This functionality will simply need to be imported into vtiger. Also, we need a link to the livechat application itself imported into vtiger. This is located in the admin/includes/[login to view URL] 14. Bulk Mass Email Communications – templates & queries a) To contact customers with a letter generated by their account representative from a template, which introduces the account representative and offers a resource for support with their order, from a person (al approach) b) To contact previous customers with orders who have not had any support requests or returns, with a letter to re-order supplies for their particular printer (per previous order) c) To contact customer who have an account, but do not have any orders. These customers should receive an templated email asking if there is anything we can help them to find, form an account representative. d) To contact customers who have placed more than one order, and thank them for our business. e) To offer discounts to customers who have placed an order, and may wish to re-order. Upon sending them a discount email, we would like to flag their user account to give a certain percentage off of their future orders. We will need a customer loyalty discount contrib. installed on OSC.
Project ID: 275037

About the project

1 proposal
Remote project
Active 16 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
1 freelancer is bidding on average $5,000 USD for this job
User Avatar
thx for invite. bid as discussed. regards, roberto
$5,000 USD in 14 days
4.8 (37 reviews)
6.0
6.0

About the client

Flag of UNITED STATES
laguna beach, United States
0.0
0
Member since Jun 5, 2008

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.