Jump to content
Sign in to follow this  
palmsgardens

Order Processing & Shipping Module v0.8

Recommended Posts

New release v 0.8 posted

 

Developped for OSC Milestone Release

 

 

http://www.oscommerce.com/community/contributions,955

 

 

03/30/2003 - Order Processing & Shipping Module v0.8 Author: P&G

 

Order Processing & Shipping Module

 

Changes v 0.8

-------------

 

1. The release v 0.8 introduce a major change

 

All tables, filenames definitions and translations are now saved in 2 tables.

You no longer have to edit files in the application in order to add new filenames or tables definitions

or edit each translation file.

 

2. an admin screen is provided to change translations or popup help info

 

3. You can now print sales conditions on your invoices.

-> you just need to add your sales conditions text to a new field in contact info admin screen

-> enable or disable printing of sales conditions on invoice in template admin

 

 

4. Fixed bugs in catalog/ order history and invoice

 

-> orders are now shown even if shipping process is not started.

-> shows correct amount if you modified order amount & shipping cost in admin.

 

5. Fixed bugs in admin/ print invoices

 

-> shows correct amount if you modified order amount & shipping cost in admin.

 

 

6. Entered more info on the popup help screens.

 

 

7. Added page comments admin screen

(Test in MS1 but can be cut and pasted in any version since it is only comment field shown)

** You need to add the extras files in zip to be able to use the admin screen

 

Basically we added comment fields to main store pages

 

product_info

default

shopping cart

payment

shipping.....

 

This modules allows you to modify comments appearing on the page directly from this screen.

 

you have the possibility to enable or disable the comment on a specific page with the red or green icon

 

Comments can be specific information to explain what client can do or explain shipping infos or payment infos

Share this post


Link to post
Share on other sites

Please tell me if this is the contribution we need for this. My boss wants our shop to collect the charge card number securely and store it on the serve and for us to manually decide if we want to fill the order or not and then for us to manually enter the charge card number if we choose to accept this order. That's not what I would do...but then, he's da boss.

Share this post


Link to post
Share on other sites
Please tell me if this is the contribution we need for this.  My boss wants our shop to collect the charge card number securely and store it on the serve and for us to manually decide if we want to fill the order or not and then for us to manually enter the charge card number if we choose to accept this order.  That's not what I would do...but then, he's da boss.

 

 

 

1. We finalised a part in our module where crypt and store credit card in a table. (you need to HAVE a SSL certificate installed on your server to process securely the cards)

 

 

2. If you are using Authorizenet our new module allows to process the card from the module instead on rekeying all infos in the virtual terminal.

 

3. once transaction is processed a table store authorisation number, and other info necessary to do a refund or a credit if needed.

 

 

if you use other payment systems you will have to develop you own code or processing manually the transaction in the payment system you are using

 

4. we just finished this part in our module and we will test it for another 2 to 3 weeks. we have a few enhancements to do for the credit part and save payment transactions history.

Share this post


Link to post
Share on other sites

Maybe im just slow but what is this contribution for?

 

Doesnt milestone already have a order processing and shipping modules?

Share this post


Link to post
Share on other sites

Dohh..

 

had a rough weekend...lol

 

This is the 'old' manual entry contribution if you remember that one

 

follow the link at the top thread to read all about it


Robert

 

We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;)

Share this post


Link to post
Share on other sites

is there a way to negate shipping with a Manual entry? i am trying to set up a kind of pos with this and i want the admin only to be able to select no shipping cost.

Share this post


Link to post
Share on other sites

Looks like a great contribution. did i do something wrong on the install?

when i go under admin > shipping > shipping processing there are no orders (even if i set status to "all orders") i can put an order id in and get a order up.

Share this post


Link to post
Share on other sites
is there a way to negate shipping with a Manual entry? i am trying to set up a kind of pos with this and i want the admin only to be able to select no shipping cost.

 

 

shipping cost modules are defined in core application

 

 

what you can do in our module is to change shipping cost to 0 if needed.

and it is done in the admin section

 

not sure it is waht you want o do

Share this post


Link to post
Share on other sites
Looks like a great contribution. did i do something wrong on the install?

when i go under admin > shipping > shipping processing there are no orders (even if i set status to "all orders") i can put an order id in and get a order up.

 

 

1. on the right top corner there is a drop down box with the

different status

 

during your store configuration , did you configure the order to have

a specific status when placed ?

 

the link on our store is configured to show by default status =1 (or

pending orders status)

 

but if you selected the orders to be saved directly with another

status , you have to use the drop down box on the top right side to

select the status you want to see

Share this post


Link to post
Share on other sites

Hi,

 

This is something that I want!!!, but Step 1?

 

Admin/database_tables.php - I cannot find this file anywhere

 

please help :oops:

 

Step 1 admin/database_tables.php

--------------------------------

add lines below

 

// define new tables for shipping module

define('TABLE_SPG_CONFIG', ' spg_config');

define('TABLE_SPG_CONFIG_LANGUAGE', ' spg_config

Share this post


Link to post
Share on other sites
if I go to the manual entry, choose my customer it opens a blank page and then it opens this link:

 

http://123.123.123.120/magicmushroomshttp:...ion=login_admin

 

it just seems to duplicate the link

 

same goes for create order button...

 

anybody knows how to fix this??

 

cheers

 

lx

 

 

the problem does not come from our module

 

 

it comes from YOUR application_top.php configuration. look at the link you put for catalog and server symbolic name

Share this post


Link to post
Share on other sites
Hi,

 

This is something that I want!!!, but Step 1?

 

Admin/database_tables.php - I cannot find this file anywhere

 

please help :oops:

 

Step 1 admin/database_tables.php

--------------------------------

add lines below

 

// define new tables for shipping module

define('TABLE_SPG_CONFIG', ' spg_config');

define('TABLE_SPG_CONFIG_LANGUAGE', ' spg_config

 

 

REVIEW the latest zip on our test site NOT on the OSC contribution

 

http://64.255.9.69/oscdownload/

 

 

depending on the snapshot your have , CORE developers created now a

 

 

file called admin/database_tables.php , if you have this file , put the variables in it.

 

 

if you do not have this file put variables in admin/includes/application_top.php

 

 

 

MAKE SURE TO DOWNLOAD LATEST ZIP FROM OUR TEST SITE !

 

http://64.255.9.69/oscdownload/

 

 

we no longer upload latest version to OSC contribution . our zip file is over limit of 300k defined by osc site.

 

 

 

 

 

 

Step 1 admin/database_tables.php (or application_top depending on snapshot)

--------------------------------

add lines below

 

// define new tables for shipping module

define('TABLE_SPG_CONFIG', ' spg_config');

define('TABLE_SPG_CONFIG_LANGUAGE', ' spg_config_language');

define('TABLE_SPG_MANUAL_INFO', 'spg_man_info');

Share this post


Link to post
Share on other sites
with this, is it possible to have a daily purchase order for all in coming orders everyday based on the supplier?

 

 

 

Yes and No.....

 

 

in other words:

 

1. we created a supplier table and a maintenance screen to link every item in your store to a supplier.

 

as well as maintaining suppliers (contact, phone.....)

 

However at present we allow only one supplier for each item. I do not know how complex is your purchasing .

 

if you purchase a specific item from only one supplier it will work perfectly

and you will be able to assign for EACH item a specific supplier of your choice entered in the supplier table

 

 

however if you have a choice of several suppliers for EACH item , in that case it will be limited to one supplier per item

 

 

2. at present we do a report developed:

 

-> items sold per supplier

 

In order to have some kind of shopping list to be printed since we use this list to get in our fields the items ordered. in other words we do not need to send this list to a third party.

 

we consider it more as a picking list for our own needs.

 

 

we did not developed a purchase order form to be printed , faxed or sent by email sorted by supplier due to tine constraints.

 

 

if one sponsor was willing to dedicate some funds , we would finalise this to be more efficient and customised to needs.

Share this post


Link to post
Share on other sites

DO NOT download zip file fromn OSC contribution site.

 

 

our module is near the 300 k limit and most of the time file is corrupted when uploaded.

 

 

go to our test site to download latest version as well as bug fixes .

we do a fix everytime we get feedbacks from users and create a zip for this fix.

 

 

in order to download our latest version , you need to go to our test server at

 

 

http://64.255.9.69/oscdownload/

Share this post


Link to post
Share on other sites

QuickEnterprises

 

Do us all a favor and kill that God awful banner from your sig. Have you noticed that virtually nobody else has one? That's because it's against the forum rules (and for whatever reason a moderator won't step up to the plate and tell you). That's what the www button is for. :wink:

Share this post


Link to post
Share on other sites

Hello,

 

I have installed this great contribution and am testing

this . Iget te following error message when I puul up

an order detil

 

Payment Method: Check/Money Order

 

 

Products Model Tax Price (ex) Price (inc) Total (ex) Total (inc)

1 x Anti - Aging Serum wth GEN III bipyramidal lyposome technology SU72030 0.00% $24.00 $24.00 $24.00 $24.00

1 x Germanium Plus-supercharge immune system and resist aging 74020 0.00% $96.00 $96.00 $96.00 $96.00

2 x DNA Repair creme wth GEN IV DNA technology for UV damage SU74200 0.00% $33.28 $33.28 $66.56 $66.56

1 x Advanced Face Cream wth GEN III bipyramidal lyposome technology SU72040 0.00% $32.00 $32.00 $32.00 $32.00

1 x Immunocal - HMS 90.- boosts immune system like mother's milk 0.00% $96.00 $96.00 $96.00 $96.00

Sub-Total: $314.56

Shipping: $0.00

Total: $314.56

 

 

 

Date Added Customer Notified Status Comments

1054 - Unknown column 'new_value' in 'field list'

 

select new_value, old_value, date_added, customer_notified from orders_status_history where orders_id = '14' order by date_added

 

[TEP STOP]

 

I have downloaded the laest files from your site but have not

loaded the files in the EXTRAS directory .

Are they supposed to replace the existing ones in the CATALOG

directory ?

 

Many thanks in advance

Share this post


Link to post
Share on other sites

I did manage to merge the code sections in the

THREE files in the EXTRAS to the one already

in my version

 

Now Iget this error message while tryng out

the cart

 

1146 - Table 'affiliatesexcel_com.TABLE_WEB_SITE_CONTENT' doesn't exist

 

select text_key, text_content from TABLE_WEB_SITE_CONTENT where page_name = 'shopping_cart'

 

[TEP STOP]

 

 

Where can I get the SQL to create this table ?

Share this post


Link to post
Share on other sites

And this

 

1054 - Unknown column 'date_status_change' in 'field list'

 

update products_comments set products_comments_status = '0', date_status_change = now() where products_comments_id = '10'

 

[TEP STOP]

 

 

rying to set the comments to inactive in the admin

Share this post


Link to post
Share on other sites

I got this address from the Install file

of the osContribution down load

 

http://64.255.9.69/oscdownload/

 

 

The site may be under maintenance now.

 

If you need it please E mail me at

sales.mystery@btinternet.com

with your FTP details and I shall upload

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×