We are currently running Oscommerce and have a need for a batch order loader. We receive many orders in an excel spreadsheet or csv file. We want to be able to select a customer and currency and sale type, then load in a csv spreadsheet of items to create an order. Must understand Oscommerce order entry system to select next order number as well as apply cost codes based on our custom modification that calculates the costs/royalty to be paid out for the product and puts that information into the orders_products table `products_sale_type` and `products_item_cost`. The system needs to be able to support multiple product identification methods, model_number, UPC, ASIN and product_id which will be in the order spreadsheet (some use UPC, others use ASIN or Model_number or product_id. Three main data elements will be product identifier (UPC or Product_ID or ASIN or Model_Number), Quantity, price. If no price is provided, then it will use the system pricing reflecitng any customer discounts. This will need to be loaded into the orders_products table along with calculating the cost structure (royalty) and sale type. Once the order is loaded, we need for it to calculate shipping using shipping modules, if any, allowing for no shipping if shippng is not required. Here are the order related tables:
ORDERS
orders_id
customers_id
customers_name
customers_company
customers_street_address
customers_suburb
customers_city
customers_postcode
customers_state
customers_country
customers_telephone
customers_email_address
customers_address_format_id
delivery_name
delivery_company
delivery_street_address
delivery_suburb
delivery_city
delivery_postcode
delivery_state
delivery_country
delivery_address_format_id
billing_name
billing_company
billing_street_address
billing_suburb
billing_city
billing_postcode
billing_state
billing_country
billing_address_format_id
payment_method
cc_type
cc_owner
cc_number
cc_expires
giftwrap
last_modified
date_purchased
orders_status
orders_date_finished
currency
currency_value
purchase_order_number
purchased_without_account
ipaddy
ipisp
customers_referer_url
shipping_tax
fedex_tracking
comments_slip
iswholesale
google_order_id
ORDERS_PRODUCTS
orders_products_id
orders_id
products_id
products_model
products_name
products_price
final_price
products_tax
products_quantity
products_sale_type
products_item_cost
products_prepared
date_shipped_checkbox
date_shipped
returned_reason_checkbox
returned_reason
item_ordered_date
camefrom
ordered
back
is_allied
date_sent_to_allied
date_ship_by_allied
days_between_allied
ORDERS_TOTAL
orders_total_id
orders_id
title
text
value
class
sort_order
ORDERS_STATUS_HISTORY
orders_status_history_id
orders_id
orders_status_id
date_added
customer_notified
comments
ORDERS_STATUS
orders_status_id
language_id
orders_status_name
Hi
We are ready to start this project now. Outstanding performers in graphical design and speed programmers,developers and coders. provide you similar functions required in this project with outstanding performance. Assure you Quality design work with affordable price .We maintain long tern business relationship. We connect daily with our clients for updated reports to submit. Select us right now. Award this project to us. Please have look on our PMB.
Hi
From the project description, I understand you want to import and create oscommerce orders. I can help you with that. Please check message board for details. Regards Shiva
Hello,
Elevation is an ISO 9001:2000 certified 100% Export Oriented Software Company has bulk of out customers are in Europe and USA.
We have got talented software engineers from leading MNCs covering the area like PHP/MySql, Joomla, Magento, Wordpress, Zen Cart, OS Commerce. We have also got the SEO experts (OnPage & OffPage) & Creative 3D Animation Works.
It would be our pleasure to work with you giving the best of services within a stipulated time framed & work with a reasonable price structure.
Please look into PMB for some of our recent projects.
Thanks & regards