Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

w3it

Pioneers
  • Posts

    77
  • Joined

  • Last visited

Posts posted by w3it

  1. Hi,

     

    We need to change the current shipping module “zones.php” it currently shows to the country and we need it to show to the State/Province tables data. The “Zone 1 Countries” in the admin panel it should have 4 groups for our Provinces:

     

    I want to use the “Products Weight” in the Catalog/Products/ to determine delivery rate for example, so "product1" will have a weight of 1 in its product description, and ‘n shipping price of 4.00.

     

    Example:

    Zone 1 Countries (Change to Province)

    Comma separated list of two character ISO country (Need to change to Province) codes that are part of Zone 1.

     

    Zone 1 Shipping Table

    Shipping rates to Zone 1 destinations based on a group of maximum order weights. Example: 1:4.00,2:3.00,3:40.00,4:30.00 Weights equal to 1 would cost 4.00, Weight equal to 2 would cost 3.00 etc for Zone 1 destinations.

     

    Are there any modules out there that does something similar, or how to edit the current zones.php.

     

    Any help will be appreciated.

    Many Thanks

    Hi Theo

    How did you get on? I am doing something similar right now. You edit the zones module to have 4 zones. Then when you install the module, you will see four zone entry methods. Enter your provinces per zone and the weight to price ratios.

     

    Ian

  2. Hi I've tried out the above but get the following when I try run the Admin install:

     

    Warning: Cannot modify header information - headers already sent by (output started at <mydomain>/catalog/includes/modules/shipping/table.php:1) in <mydomain>/catalog/admin/includes/functions/general.php on line 18

     

    I?m using 2.2 MS2

     

    Thanks,

     

    Mark

     

    Hi

    I had this. Its actually the bottom line. Make sure there are no blank line outside the <?php tags.

     

    Ian

  3. how good is your SQL? That error denotes something is wrong with the SQL comment. At first glance and until I get this module installed try this:

     

    select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by limit '0, 20'

     

     

    I'm hoping to get to this module soon. So I will play catch up then.

    Ian

  4. Hi

    been reading this thread and wondered how easy/stable this contribution is under both MS1 and MS2. Any problems or suggestions, that I should be aware of?

     

    I have a virgin MS1 and MS2 but one shop is a "mess" of contributions and I wondered what experiences people have been having.

     

    Thanks for any response.

    Ian

  5. I just haven't had time to read that thread yet.

     

    I know the urge is to "install and go" but just look at how much time has been involved in sorting out issues. It takes 10 minutes to read the manual and get an understanding. 30 seconds for the text file that comes with the image mod.

     

    I cannot back loxly enough. Read up and become your own expert. Its worth it in the end.

     

    "duplicate products" ... impossible if you follow how to setup correctly with EP. Its a database thing! The db will not allow duplicate records... it will allow duplicate product names though... hint!

     

     

    Best

    Ian

  6. The other question I have is why does it say coming soon on product info page and how to get rid of it??

     

    If I haven't said it enough......Thank you!

     

    You really need to read the manuals. Read the text file that comes with dynamic mo pics.

     

    Ian

  7. Now that I think about it, I believe dynamic mo pics requires adding to product_info.php. I guess I put it in the wrong part...I'll have to try to fix that when I get off work

     

    Yes it does and for every language too. Check your <table> tags layout...

     

    Ian

  8. Now that I think about it, I believe dynamic mo pics requires adding to product_info.php. I guess I put it in the wrong part...I'll have to try to fix that when I get off work

     

    Yes it does and for every language too. Check your <table> tags layout...

     

    Ian

  9. Glad you worked it out and reported back. Reading is a wonderful thing, and understanding how a contrib works and what it is intended to do are very important to the whole process.

     

    Absolutely!

     

    I made a mod to MS1 so that when the upload completes, instead of an error message, you will now see a message that it completed ok. I also added a record count so you see how many products were actually uploaded.

     

     

    Best

    Ian

  10. Everytime I make any changes in eastpopulat.php I get parse error...very annoying

     

    Follow Loxlys advice and readup on the mod and what you need to do. In EP, where it says uncomment, thats all you need do. Do not edit the other code at will if you do not know what you are doing. The error 1690 and the parse errors you mentioned point to more than just uncommenting.

     

    Have a good weekend...

    Ian

  11. Quote:

    No products_model field in record. This line was not imported

     

     

    This line appears at the end of every successful upload.

     

    I get this after every product, but nothing shows in catalog or admin

     

     

    Yes I am an end user, however, I don't have much experience. The only reason I'm looking at using this is I have a supplier who has the products in a dat file. I am putting together another store under MS2 using different products than my MS1 store. I really don't want to hand input 250+ items. I know I'm getting close, I'm in the process of changing the field names. I wanted to use big images, but it doesn't work on MS2, so I'm installing dynamic mo-pics and having trouble configuring. I have 2 sets of images, 1 set thumbs, 1 set regular size. I want the thumbs for product_info and the reg for pop-up.

     

    Can your hosting service help or is it a "we offer but dont support" hosting package you have? Its like loxly was hinting at, if you are moving away from the "standard" install that your hosting company provide, then you will need to know what buttons to push. I take it you have read the manual? Have a go with the images, if you dont have any success, dare I say it... come on back!

     

    Seriously though, think about a supported oscommerce service, you might find it a lot cheaper in the long run.

     

    Best

    Ian

  12. No products_model field in record. This line was not imported

     

    This line appears at the end of every successful upload.

     

    It is looking for more products and you have to come to an end at some point!

     

    It is NOT a real error.

     

    Hi Loxly

    to put you in the picture as this has been a bit of an epic, in chfields case he has not had a successful upload at all.

     

    If EP cannot find a field called "product_model" then EP exists with an error "No products_model field in record. This line was not imported", that much is true. However it is not the case that it appears at the end of every successful upload. It can appear in an unsuccessful upload too.

     

    It is merely the last loop of an if statement in the code and unfortunately instead of there being one more loop to say "file upload success" (maybe I'll put that mod in?), the current program simply finishes by displaying this error message. It seems someone informed you that this can be interpreted as being a successful upload.

     

    The message says "No products_model field in record. This line was not imported" - and that is exactly what it means. Yes it does display it at the end of a successful upload... it also displays it when the "products_model" is not found.

     

    To demonstrate. Take a .txt file and rename the products_model field to sku (or something). Run EP and you will see this output below:

     

    ................................................................................

    ........

    File uploaded.

    Temporary filename: /tmp/php8fqcrB

    User filename: mpqtest.txt

    Size: 94

    | 15000 | 480 | 1000

     

    No products_model field in record. This line was not imported

     

    | 19110 | 40 | 1000

     

    No products_model field in record. This line was not imported

     

    | | |

     

    No products_model field in record. This line was not imported

    ................................................................................

    ........

     

    Two records, a blank line(EOF) and no products_model field will give 3 error messages. The actual problem is that there is no check for the end of the file, EOF, which could then display a message like <b>upload successful</b>.

     

    It IS a real error and the fault lies in the way the program terminates. However you will not read that in the manual.

     

    Best

    Ian

  13. Do they have to be in a specific order? I mean, will I need to be switching all my columns around?? Also, I have big images installed and when I did a download of my current products, it only included my thumbnails and not my originals. I noticed in the code it shows products_bimage but it didn't pull it down.

    I asume when uploading I will need to create that column and populate accordingly?

     

    Hi

     

    I'll have a look through the code.

     

    FIELD SEPERATOR

    Here is something I missed that might help you. You can set your OWN field seperator! No need therefore to replace what you had with TABs. Sorry about that.

     

    COLUMN PLACEMENT

    From looking at the code, no you do not need to specify the column layout. You must lable the columns with the EP know column field names but you do not have to move them around.

     

    IMAGES

    You have a lot of questions! Are you an end user? I take it your hosting company does not give you much support! I found code that will support an image mod. You might like to look into that.

     

    We'll get there...

    Ian

  14. I see...I guess that saves time if your downloading your current products to edit, but thats a lot of work to have to create the entire spreadsheet to upload all new products, just as fast to enter through admin. Thanks for the help!!  

    I appreciate you taking your time to make me understand. I will have to play with it to make it fit my needs.  

     

     

    Again many thanks!!

     

     

    Hi

     

    hold your horses! All you have to do is match your table fields to the EP table fields. I would rather do that than type 5 products in by hand. For example SKU replace with v_product_model, weight replace with v_weight, etc. Drop the itemid column.

     

    If you still do not see, tell me and we'll try to clear this up, as typing all your products in is what EP is built to automate! That is the point of EP.

     

    I'm obviously not getting my point across if you think typing everything in will take just as long. Out of interest, how many products are you thinking of entering?

     

    Best

    Ian

  15. Ok I changed to tab delimited in excel, saved as text file uploaded and still got this on all my products

     

    | 593 | 001AVIA ST | Accessorie | AVIA | SATELLITE | SPKR-AS1 | avia_spk_s | 99.95 | 38 | 9 | 18 | ########## |  for | set the b | twist the | set your | ########## | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Active

     

    No products_model field in record. This line was not imported

     

     

    Here is first lines of my excel spreadsheet

     

    itemid sku category brand item Products_model pic retailprice price instock weight description                                                                                    EOREOR

    593 001AVIA STANDS Accessories AVIA SATELLITE SPEAKER STANDS SPKR-AS1 avia_spk_stands.JPG 99.95 38 9 18 ################################################################################

    #################################################################################

    #################################################################################

    #############  for the best sound  possible. </LI><LI>To use these speaker stands  set the base on the floor  twist the poles into place  set your speakers on the poles and run the wire up through the stand ################################################################################

    #################################################################################

    #################################################################################

    #############                                                                              Active EOREOR

     

    Well I can see where the confusion lies! EP expects the .txt file to have headings like the following:

     

    v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_products_head_title_tag_1 v_products_head_desc_tag_1 v_products_head_keywords_tag_1 v_products_name_2 v_products_description_2 v_products_url_2 v_products_head_title_tag_2 v_products_head_desc_tag_2 v_products_head_keywords_tag_2 v_products_name_3 v_products_description_3 v_products_url_3 v_products_head_title_tag_3 v_products_head_desc_tag_3 v_products_head_keywords_tag_3 v_products_name_4 v_products_description_4 v_products_url_4 v_products_head_title_tag_4 v_products_head_desc_tag_4 v_products_head_keywords_tag_4 v_products_price v_products_weight v_date_avail v_date_added v_products_quantity v_manufacturers_name v_categories_name_1 v_categories_name_2 v_categories_name_3 v_tax_class_title v_status EOREOR

     

    You will have to rename all the columns to support this. Also, make sure to include v_status where you have "active" in the data. When you make a download .txt using the EP system, you will see these headings. The headings you have are standard, but not what EP is expecting for it to work.

     

    For furher information and an "understanding of what you are using"... read the documentation.

     

    Best

    Ian

×
×
  • Create New...