Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Manual Entry question


RickChase

Recommended Posts

I am using the Manual Entry 03 mod and it is working great, but I have two questions.

 

Is it possible to search for customers by implementing a search box? How would one go about doing this?

 

Also, I am about to import all of our customers - about 40,000 of them. Can the drop-down list handle this? I would rather just search for a name than have to load the entire list in a drop-down as designed.

 

Thanks,

Rick

Link to comment
Share on other sites

  • Replies 54
  • Created
  • Last Reply

Top Posters In This Topic

We can create a new screen for store managers having thoyusands of customers

 

drop down may be very slow and not very convenient

 

 

we will try to incorporate this functionality in v0.7

Link to comment
Share on other sites

Warren:

 

 

Manual entry is now called the following.

 

 

Shipping, Order Processing module v.06

 

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

 

 

Version 0.6 has just come out as of 2-10-03. However, I have sent an email to P&G because the zip files have password protected areas thoughout the unzipping process. In addition its full of strange file names. I am waiting for an email confirmation from P&G on these questions before I try an update my Shipping, Order Processing module v.05. Also, I have asked P&G to post a sticky in the contributions section, because I am sure other people will have questions too.

 

 

Razor Sharp :lol:

Link to comment
Share on other sites

I uploaded a new zip file called v06a.zip

 

 

1. there ais normally no password in our zip file

thus i do not know why you get a request for a password

 

2. I tried several times to extract zip file v0.6 and could not

replicate your error where part of file name is cut.

 

not sure what could be the problem

 

 

what environment are you working on ?

 

 

Anyway I recreated zip file and uploaded it in the contribution : new zip is v06a.zip

 

 

let me know if it is working

Link to comment
Share on other sites

I had QTpro v2.0 installed (an inventory mod that assigns quantities to attributes) and when I installed Shipping, Order Processing module I had some serious problems (products_attributes.php was overwritten). Does this Shipping, Order Processing module keep track of inventory by products attributes or do I have to try and force these two to work togeather?

Nothing Unreal Exists

Link to comment
Share on other sites

we will check the module QT pro to see what it does

 

think would be quite easy to add a falg in our module to avoid updating attributes if qt pro is intalled

 

will be added for v 0.7

Link to comment
Share on other sites

I have gotten it to work actually, thanks.

 

I think QTPro would be a great addition since its rather popular, doesn't force the admin to use it and gives great flexability over inventory. (however, if you do so you might want to incorporate my patches on the QTPro thread. It has a couple serious bugs.) :wink:

Nothing Unreal Exists

Link to comment
Share on other sites

Received the following error in /spg_suppliers_products_cost.php

 

1054 - Unknown column 'p.products_cost' in 'field list'

 

select distinct p.products_id, p.products_price, p.products_cost, p.products_weight, pd.products_name from products p, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' order by pd.products_name limit 0, 20

 

 

[TEP STOP]

 

 

Any idea??

Link to comment
Share on other sites

when i goto orders to process and click a order i get this error

at the bottom of the page under the comments form .

 

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

 

select new_value, old_value, date_added, customer_notified from orders_status_history where orders_id = '17' order by orders_status_history_id desc

 

[TEP STOP]

 

 

 

 

also

 

 

when i goto product cost i get this error :

 

 

Product Admin

 

Products Id Product Cost Price Weight Action

1054 - Unknown column 'p.products_cost' in 'field list'

 

select distinct p.products_id, p.products_price, p.products_cost, p.products_weight, pd.products_name from products p, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' order by pd.products_name limit 0, 20

 

[TEP STOP]

 

 

 

 

 

i have also noticed that there are some define statments missing or something as i have thing like

 

BOX_UTILITIES_ATTRIBUTES

 

showing up under the utilites menu and other in varying

places under menus......

 

i have searched all the included files for the define statement

but there not there.

 

 

any help with these problem ?

thanks in advance !

Link to comment
Share on other sites

also getting places where test is not defined

in order emails

 

 

Teksigns Online Store

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

Order Number: 17

Detailed Invoice: https://www.mystore.com/shop/account_histor...php?order_id=17

Date Ordered: Friday 14 February, 2003

 

EMAIL_TEXT_STATUS_UPDATE

 

 

 

 

i think the email_text_status_update

should have been replaced with something from a define

somewhere .

 

 

can someone shead some light on these problems ....

 

thank you

 

Please ...............

Link to comment
Share on other sites

1054 - Unknown column 'p.products_cost' in 'field list'

 

Add this column to the table 'products' in myphpadmin:

products_cost decimal (15,4) Null

 

that worked for me!

 

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

 

Not sure about this one...dont' think I had that problem...better restore your backup and try installing again, just to be sure you did it correctly.

 

there are some define statments missing

 

Yup...go and define them

I had to define at least three or so myself, can't remember which ones.

 

 

Also, there was an SQL in spg_shipping.php that has a null entry for an update. That was giving me an 'wrong number of columns' error, so I just removed the '' entry from the end and now it works great. Just a note in case someone else has the problem.

Nothing Unreal Exists

Link to comment
Share on other sites

Question about to the Manual Entry fucntion

 

Let say a customer ordered 3 different items.

I am able to ship 1 of the items out only. How can I make the other 2 items to backordered and how does the customer knows which items are backordered.

 

Thank you

Link to comment
Share on other sites

1054 - Unknown column 'p.products_cost' in 'field list'

 

that was it

thank you paul.

 

 

 

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

 

solved needed new field in table

 

 

 

solved

 

EMAIL_TEXT_STATUS_UPDATE

 

 

problem also by adding :

 

require('includes/languages/english/orders.php');

 

 

to the top of spg_shipping.php

right above

 

require('includes/application_top.php');

 

 

 

 

 

still have lots of variables showing up on the

utilities_attributes.php page

 

 

i would create my own defines and fix them

but i dont know what its supposed to say .

Link to comment
Share on other sites

i sell custimizable items also .

 

and such item all have differnet prices

depending on what they order .

 

theres really not a way to setup a item

that will fit all .

 

 

what do i need to change to be able to input

custom item destription price and item number

during a manual transaction .

 

 

sometimes i get a call in for items in my cart.

and custimized items.

 

 

custimized items being signs,decals , etc

Link to comment
Share on other sites

i have about 500 products in my database

 

they all come from the same supplier ......

but im about to add another 1000 products

from a different supplier .

 

 

how can i update the 500 to all point to the

same supplier before adding the others .

 

 

are there maybe some code where you could

display like 50 per page with check boxes

and check the ones you want and select a supplier

on the bottom of the page .

 

 

please reply.

 

thanks

Link to comment
Share on other sites

how can i update the 500 to all point to the

same supplier before adding the others .

 

Enter the supplier you want for the 500 into the DB from the admin section. Then go into myphpadmin and select the table spg_suppliers. Get the supplier id number for the supplier you just entered. Then go to the table spg_suppliers_products and make sure the existing 500 products all have that supplier ID. Then add your new products and supplier. Assign the new products to the correct supplier through the admin panel.

Nothing Unreal Exists

Link to comment
Share on other sites

thats a lot of clicking for 500......

 

i would have to select from the dropdown

and select a supplier for each one

click update .....

 

 

that would take hours

 

 

theres bound to be a easy way to create these new tables

instead of all the clicking .

Link to comment
Share on other sites

Run an SQL Query:

 

"Update spg_suppliers_products SET spg_suppliers_id = <insert id here>"

 

That will update all of them

just make sure you want every product in the table linked to that supplier. And be sure to make a backup.

Nothing Unreal Exists

Link to comment
Share on other sites

we will update this weekend the zip contribution to v0.6d

 

It will contain a utility to update in bulk the suppliers_ id with a supplier of your choice.

 

will do same thing as going to phpmyadmin but just easier for persons not very familiar with sql select statements

Link to comment
Share on other sites

will update zip file this weekend with missing text variables.

 

latest version of languages files was not in zip file

 

zip will be updated to v0.6d and updated this weekend

Link to comment
Share on other sites

1054 - Unknown column 'p.products_cost' in 'field list'

 

Add this column to the table 'products' in myphpadmin:

products_cost decimal (15,4) Null

 

 

 

 

This didn't work for me, any other suggestions? This is my only prblem so far. HELP!

 

Webdeva

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...