RickChase Posted February 5, 2003 Share Posted February 5, 2003 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 Quote Link to comment Share on other sites More sharing options...
Guest Posted February 9, 2003 Share Posted February 9, 2003 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 Quote Link to comment Share on other sites More sharing options...
Waza04 Posted February 10, 2003 Share Posted February 10, 2003 Can anybody give me the link to this contribution. Thanks, Warren Quote Link to comment Share on other sites More sharing options...
Guest Posted February 10, 2003 Share Posted February 10, 2003 hello v0.6 is posted under features title: Shipping, Order Processing module http://www.oscommerce.com/community/contributions,955 Quote Link to comment Share on other sites More sharing options...
RazorSharp Posted February 10, 2003 Share Posted February 10, 2003 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: Quote Link to comment Share on other sites More sharing options...
Guest Posted February 10, 2003 Share Posted February 10, 2003 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 Quote Link to comment Share on other sites More sharing options...
RazorSharp Posted February 10, 2003 Share Posted February 10, 2003 P&G Verion v.06a worked fine. Everything is working great now. No more truncated file names. Thanks for the quick response. Thanks Razor Sharp Quote Link to comment Share on other sites More sharing options...
sloughwi Posted February 11, 2003 Share Posted February 11, 2003 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? Quote Nothing Unreal Exists Link to comment Share on other sites More sharing options...
Guest Posted February 12, 2003 Share Posted February 12, 2003 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 Quote Link to comment Share on other sites More sharing options...
sloughwi Posted February 12, 2003 Share Posted February 12, 2003 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: Quote Nothing Unreal Exists Link to comment Share on other sites More sharing options...
Guest Posted February 14, 2003 Share Posted February 14, 2003 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?? Quote Link to comment Share on other sites More sharing options...
teksigns Posted February 14, 2003 Share Posted February 14, 2003 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 ! Quote Link to comment Share on other sites More sharing options...
teksigns Posted February 14, 2003 Share Posted February 14, 2003 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 ............... Quote Link to comment Share on other sites More sharing options...
sloughwi Posted February 14, 2003 Share Posted February 14, 2003 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. Quote Nothing Unreal Exists Link to comment Share on other sites More sharing options...
Guest Posted February 14, 2003 Share Posted February 14, 2003 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 Quote Link to comment Share on other sites More sharing options...
teksigns Posted February 14, 2003 Share Posted February 14, 2003 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 . Quote Link to comment Share on other sites More sharing options...
teksigns Posted February 14, 2003 Share Posted February 14, 2003 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 Quote Link to comment Share on other sites More sharing options...
teksigns Posted February 15, 2003 Share Posted February 15, 2003 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 Quote Link to comment Share on other sites More sharing options...
sloughwi Posted February 15, 2003 Share Posted February 15, 2003 how can i update the 500 to all point to thesame 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. Quote Nothing Unreal Exists Link to comment Share on other sites More sharing options...
teksigns Posted February 15, 2003 Share Posted February 15, 2003 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 . Quote Link to comment Share on other sites More sharing options...
sloughwi Posted February 15, 2003 Share Posted February 15, 2003 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. Quote Nothing Unreal Exists Link to comment Share on other sites More sharing options...
Guest Posted February 15, 2003 Share Posted February 15, 2003 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 Quote Link to comment Share on other sites More sharing options...
Guest Posted February 15, 2003 Share Posted February 15, 2003 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 Quote Link to comment Share on other sites More sharing options...
sloughwi Posted February 15, 2003 Share Posted February 15, 2003 Will you release the updates as a patch? I really don't want to have to go and do all the customizations over again! If you could release a .zip w/ just the changed files that would be great. Quote Nothing Unreal Exists Link to comment Share on other sites More sharing options...
webdeva Posted February 20, 2003 Share Posted February 20, 2003 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 Quote Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.