Closed

Batch order loader for Oscommerce

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

Evner: OSCommerce, PHP, SQL

Se mere: batch order sale, sql create table price, sale codes, product pricing spreadsheet, customer support cost, csv codes, batch data entry, oscommerce batch orders, oscommerce next order, upc codes oscommerce, oscommerce loader, upc codes, Order, data loader, customer spreadsheet, calculating, batch, batch file, pricing tables excel, upc php

Om arbejdsgiveren:
( 3 bedømmelser ) Tampa, United States

Projekt ID: #614901

13 freelancere byder i gennemsnit $349 på dette job

NickolaS

Hi, please, check your PM

$250 USD in 2 dage
(327 bedømmelser)
7.5
netsolve

Glad to work, escrow preferred. Thank you.

$250 USD in 0 dage
(306 bedømmelser)
7.4
codersam

We are very expert on oscommerce,zencart,virtumart, magento and shopping [login to view URL] have done many ecommerce related [login to view URL] did many complex work of oscommerce,zencart,virtumart, [login to view URL] from my previous experience I Flere

$250 USD in 7 dage
(137 bedømmelser)
7.3
Shalena29

will be done

$350 USD in 5 dage
(100 bedømmelser)
6.8
Msolutions7

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. Flere

$299 USD in 7 dage
(53 bedømmelser)
6.7
ecartsolutions

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

$250 USD in 3 dage
(247 bedømmelser)
6.3
rajawi9999

Please Check PM

$450 USD in 7 dage
(128 bedømmelser)
6.2
agstech123

Hi, please check PMB to know more about our technical expertise and capabilities. Regards, Ricku Lohar

$600 USD in 8 dage
(13 bedømmelser)
6.1
sajjj

hi wyattde, please check PM for bid details thanks sajjj

$550 USD in 7 dage
(29 bedømmelser)
6.1
swamiwebservices

lets start

$250 USD in 2 dage
(73 bedømmelser)
5.4
DomainElevation

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 Flere

$440 USD in 12 dage
(0 bedømmelser)
0.0
angelthangarajan

Please check Inbox

$300 USD in 3 dage
(0 bedømmelser)
0.0
kedar00

We are a team of dedicated, serious and highly experienced developers interested in your project.

$300 USD in 10 dage
(0 bedømmelser)
0.0