Delivery control

...add ability to control and record deliveries for your Zen-Cart catalogue.
Ability to add/delete deliveries (supplier, date expected), add/delete product to/from each delivery.
Mark deliveries as delivered/undelivered and upadets stock.

Not tested with stock_by_attribute contribution.

This contribution is copy of working version in my cart.

Some modification may be needed to work with your Zen-Cart.

If in doubt or have any questions -> [email protected]

Download: http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=880

loutka:

...add ability to control and record deliveries for your Zen-Cart catalogue.
Ability to add/delete deliveries (supplier, date expected), add/delete product to/from each delivery.
Mark deliveries as delivered/undelivered and upadets stock.

So, if I understand correctly, I would use this to track stock coming into my store? If my supplier has shipped etc?

Yes...

It is used for easier stock entry and better delivery control.

You can create an order, when you make an order with your supplier.
Than mark is as delivered, when you receive it, and your stock will be updated.

Clear?

New version:
v1.1 - changed plus/minus sign in delivery.php and delivered.php on line 56/57

Hello Loutka,

Looks really good in the picture, and the idea sounds great. I had a problem uploading the SQL. It came back failed. I have a prefix of zen_ for my tables, but usually sql works ok.

Regards,

Heathenmagic

I have a problem blow, pls help me.

**Sorry, your security clearance does not allow you to access this resource.

Please contact your site administrator if you believe this to be incorrect.

Sorry for any inconvenience.**

What i have to do!?

hosiya:

I have a problem blow, pls help me.

**Sorry, your security clearance does not allow you to access this resource.

Please contact your site administrator if you believe this to be incorrect.

Sorry for any inconvenience.**

What i have to do!?

Hi,
when do you get this message? Is there any connection with this module?

HeathenMagic:

Looks really good in the picture, and the idea sounds great.

Thanks.

HeathenMagic:

I had a problem uploading the SQL. It came back failed. I have a prefix of zen_ for my tables, but usually sql works ok.

Hi, prefix zen_ is the problem probably...

You should create two tables delivery and delivery_products to work with this module. It's not written very smart, but it's working. :lookaroun

So solution could be:

1. make tables without prefix zen_
   or
2. change all instances of tables delivery, delivery_products, products_description and products in module's source code

The second solution is wiser :wink: I'll fix this in next version...

Let me know if that helped...

loutka:

Hi,
when do you get this message? Is there any connection with this module?

I installed the DB table in my mysql DB, then upload all files.
Entered to admin section, when i,m clicking the Deliviry item in admin top menu, i will go to the page that showing this message!!!

Obviously you have Admin Conrol module installed, right?

Go to Tools -> Admin Settings and make sure 3 checkbuttons for delivery files (at very bottom) are checked.

Let me know if that helped...

When I try to install the SQL Patch through ZenCart it comes back as failed, when I try to install the SQL Patch through PHPMyAdmin I get an error that says
Error

SQL query:

CREATE TABLE delivery ( del_id double NOT NULL AUTO_INCREMENT ,
del_name varchar( 60 ) default NULL ,
del_date date default '0000-00-00',
del_status tinyint( 1 ) default '0',
del_delivered date default '0000-00-00',
PRIMARY KEY ( del_id )
) CREATE TABLE delivery_products ( del_id double NOT NULL default '0',
prod_id double NOT NULL default '0',
prod_quantity double default '0'
)
**MySQL said: **
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE delivery_products (
del_id double NOT NULL default '0',
`' at line 10

I had the same issue on my 1.37 install

I fixed it by manually creating the tables

i dont have much more than that though... the delivery report shows up under REPORTS in admin but the buttons dont work and there is no data and no real instructions to guide me in the right direction...

I am saddened to say that this is a mod in dire need of some sort of support / manual for use

Please please someone who knows more than us mere mortals give us some clue :)

great idea for a mod :)

Hi,
I have cereated this mod and made it working fine for me...

I'll try to put together some manual and clean the source code, to be more transparent.

Coming back soon... ;-)

many thanks :)

hosiya:

I have a problem blow, pls help me.

**Sorry, your security clearance does not allow you to access this resource.

Please contact your site administrator if you believe this to be incorrect.

Sorry for any inconvenience.**

What i have to do!?

Click on tools / admin settings look fo the orange P and give yourself permission to open the file.

Try installing the first create table and then the second create table.

The second insert is to fast after the first one and cause it to give an error.

Inserting it seperately will do the trick.

The SQL error comes simply from the fact that the statements don't end with a semicolon. The code should be :

CREATE TABLE delivery (
del_id double NOT NULL auto_increment,
del_name varchar(60) default NULL,
del_date date default '0000-00-00',
del_status tinyint(1) default '0',
del_delivered date default '0000-00-00',
PRIMARY KEY (del_id)
);

CREATE TABLE delivery_products (
del_id double NOT NULL default '0',
prod_id double NOT NULL default '0',
prod_quantity double default '0'
);

However, I have the same problem of the buttons don't work and how on earth am I supposed to use this mod anyway? We need some very basic instructions here.

I have repaired the error in the sql table.

That is not the only issue we experience here.

The mod buttons does not work on all the systems.

I think it has to do with the fact that it was specifically written for php 4 or 5

Can anyone clear this up for me ???

I've installed eveything, but it won't allow me to add any deliveries. No error messages, just 'Delivery' at the top and the rest of the page is blank.

Hi guys,

When i try to add a delivery i get the following error:

1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT MAX(del_id) FROM delivery)' at line 3
in:
[SELECT del_id AS id FROM delivery WHERE del_id = (SELECT MAX(del_id) FROM delivery) ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

any suggestions??