Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Order Processing & Shipping Module v0.8


Guest

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

Link to comment
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.

Link to comment
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.

Link to comment
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 ;)

Link to comment
Share on other sites

  • 2 weeks later...

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.

Link to comment
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

Link to comment
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

Link to comment
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

Link to comment
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

Link to comment
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');

Link to comment
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.

Link to comment
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/

Link to comment
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:

Link to comment
Share on other sites

  • 3 weeks later...

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

Link to comment
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 ?

Link to comment
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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...