Closed

Custom Volusion SQL Query

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.

Skills: Database Administration, MySQL, SQL, Volusion

See more: SQL Query, b2, multiple warehouse, create sql report, sql different, picking sheet, 2013 query, volusion query, order picking, sql create report, volusion report, custom report volusion, custom report item, sql warehouse, volusion sql custom report, volusion custom sql query service, volusion custom query, multiple times different, print sql, moodle admin custom query sql, volusion custom report query, volusion custom sql, volusion custom sql query, volusion custom report, need sql query

About the Employer:
( 0 reviews ) United States

Project ID: #4742179

16 freelancers are bidding on average $459 for this job

akiles99

will be done..

$700 USD in 7 days
(92 Reviews)
5.6
H3Solutions

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

$368 USD in 3 days
(7 Reviews)
5.4
truongngocthanh

Please check your PM for more detail. Thanks

$400 USD in 7 days
(19 Reviews)
4.9
developerscott

Volusion expert that can get this done right

$722 USD in 5 days
(11 Reviews)
4.8
Reza2012

I want to do the project. thanks.

$555 USD in 15 days
(6 Reviews)
3.9
vickkey7

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

$526 USD in 15 days
(5 Reviews)
3.7
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.4
aladin888

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

$250 USD in 3 days
(3 Reviews)
2.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
(2 Reviews)
2.5
mdakteruzzaman

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

$250 USD in 3 days
(4 Reviews)
1.7
manjusha02

Can we start now?

$277 USD in 3 days
(1 Review)
0.0
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
(0 Reviews)
0.0
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