Custom Volusion SQL Query

Closed Posted Jul 19, 2013 Paid on delivery
Closed Paid on delivery

We're looking for someone with volusion experience.

We need to create a saved sql query for orders pending shipment in our volusion store.

We need a report to print out all orders from the previous night on one sheet with just the items and the quantities that need to be picked from our warehouse to be shipped. If possible, we would like the list to be categorized in regards to the warehouse location in alphabetical and numeric order (i.e. - A1; A2; B1: B2, etc.).

In other words: if we had 100 orders and within those orders there was a part ordered 20 times out of the 100 orders, this report will list the item once with a quantity of 20 and the location. We want to avoid picking the same item multiple times from different invoices.

Many thanks in advance.

Database Administration MySQL SQL Volusion

Project ID: #4742179

About the project

15 proposals Remote project Active Aug 25, 2013

15 freelancers are bidding on average $442 for this job

truongngocthanh

Please check your PM for more detail. Thanks

$400 USD in 7 days
(71 Reviews)
6.4
Reza2012

I want to do the project. thanks.

$555 USD in 15 days
(38 Reviews)
5.0
vickkey7

I am ready to star this project........ thanks

$526 USD in 15 days
(11 Reviews)
4.3
mdakteruzzaman

Expert in Database administration and Management more than 9 years. pls check pmb

$250 USD in 3 days
(20 Reviews)
4.8
ashuagrawal

Sir, I have read the project details clearly and am ready for it. I can assure you of perfection in my work and the work will be of high accuracy. Please provide more information about the project. Eagerly waiting for More

$277 USD in 3 days
(8 Reviews)
3.8
H3Solutions

We deliver quality with excellence. We have done similar work. More info in PM

$368 USD in 3 days
(8 Reviews)
5.8
aladin888

HI, DO YOU NEED A PHP/MYSQL CODE OR JUST A SIMPLE SQL CODE "SQL SAVED PROCEDURE" ??

$250 USD in 3 days
(7 Reviews)
3.1
miniric3

Kia ora! mulvays are a NZ based web and software design company who have seen you here on the freelance market and are really excited about working with you and treating you to the full service, professional experience More

$773 USD in 21 days
(2 Reviews)
4.8
huzaifaatlancer

Hi Please check my message!! Thanks.

$277 USD in 3 days
(2 Reviews)
2.6
manask1703

Hi I am Krishna, Sr. ETL Developer located in India. I would love to have the opportunity to interview with you about your posting. Details of my skills and experience as well as sample of work can be viewed here More

$555 USD in 3 days
(3 Reviews)
2.7
manjusha02

Can we start now?

$277 USD in 3 days
(2 Reviews)
2.8
on2it

Kia ora! on2itonline are a NZ based web and software design company who have seen you here on the freelance market and are really excited about working with you and treating you to the full service, professional experi More

$721 USD in 21 days
(0 Reviews)
0.0
jdabrowski

Hello, I'm interested in this task. I have vast experience with SQL and I can prepare optimized solution.

$300 USD in 7 days
(0 Reviews)
0.0
ghanchiasif

I can do this.

$833 USD in 3 days
(0 Reviews)
0.0
emmafreelancer

I have studied the website and also create a trial account. From the export page, I could retrieve all the basic information. For your requirement, I believe I still to know more details before I could provide the SQ More

$266 USD in 3 days
(0 Reviews)
0.0