Jump to content

roback

Members
  • Content count

    69
  • Joined

  • Last visited

Posts posted by roback


  1. All, I have installed this addon and so far it works great functionally. I made a couple adjustments per this thread and all seems to work well.

     

    My problem is cosmetic and I am having a heck of a time getting this to blend into my site. I currently only have it on my test server, so can't show a live copy of it but maybe some insight into the whole infoBox call/function for styling. My templated cart has the info boxes styled for the left column, but I am trying to place this in my content area and format it nice and neatly, but could not.

     

    Could somebody help me to format this a little better? Is there maybe a way, with some help, for me to copy the default infoBox fucntions to say infoBox4 and modify what I need to (though would need help with this.) (Doesn't have to infoBox, could be contentBox all the same... at least from what I gather?)

     

    Any help?


  2. am I missing something? Is it named something else?

     

    Search: -- All Categories --Credit ModulesFeaturesImagesInfoBoxesLanguagesOrder Total ModulesPayment ModulesReportsShipping ModulesTemplates and ThemesZonesOther << Page 1 of 1 >>

     

    Package Title Target Last Update

    SEO Assistant 2.2 25 Aug 2009

    All Products v3.0 MS 2.2 with Images 2.2 30 Jun 2009

    Dynamic SiteMap V 1.0 2.2 22 Jun 2009

    Dangling Carrot 2.2 16 Apr 2009

    Shipping Surcharge 2.2 24 Mar 2009

    Google Position 2.2 29 Dec 2008

    Site Search 2.2 14 Nov 2008

    Header Tags Controller 2.2 9 Apr 2008

    PostIt V 1.0 2.2 2 Dec 2007

    Links Manager For OSC v0.20 2.2 5 Jul 2007

    Shadow Controller 2.2 21 Sep 2006

    RSS News 2.2 10 Sep 2006

    Easy Menu Maker V 1.0 2.2 1 Feb 2005

    Category Count 2.2 6 Jan 2005

    PageMaker 2.2 9 Nov 2004

    FormController 2.2 3 Nov 2004

    Customer Login 2.2 12 Aug 2004

    EmailEncoder 2.2 5 Apr 2004

     

    Total: 18 packages << Page 1 of 1 >>

     

    Is there no way to do this with a simple calculation prior to the order total variable being passed?


  3. I am operating a site in Belize with prices in Belize Dollars. I am trying to set up 2CO as it is one of few options available for online CC transactions in Belize. The small problem I am encountering is that my prices are in Belize Dollars and 2CO only functions in USD (well that is the easiest closest option for us as 2 BZD = 1 USD fixed exchange).

     

    So I need help figuring a way to convert from Belize Dollars to US dollars before passing values to 2CO only if 2CO is selected as payment option. Not sure either, but probably a way to convert back to BZD once the 2CO portion is complete and passed back to our site.

     

    Any help with this would be greatly appreciated.

     

    Thanks

     

    Rob


  4. you are making this way more complicated then it needs to be. The only thing you need to do is enable the feature in the easy populate settings. Look for this setting at the top of the easypopulate.php file: EP_EXTRA_FIELDS_SUPPORT. make it true. read the instructions on how to use the extra fields support in the easy populate docs. create your file, import your data. done deal.

     

    Okay, I set the EP_EXTRA_FIELDS_SUPPORT to true: Per admin side column: "Extra Fields: true"

     

    Now I have read and reread the installation instructions pertaining to Extra Fields bit and I am still a bit unclear.

     

    I have created the following file as an example:

    v_products_model,v_products_extra_fields_name,v_products_extra_fields_id,v_produ
    cts_extra_fields_value,EOREOR
    123,Size,6,17.5,EOREOR
    123,U.O.M,7,oz,EOREOR
    123,Distributors,1,Brodies,EOREOR

     

    This so I can view and change the size, UOM and Distributor of the product model 123.

     

    Now I am unclear on where I upload this to and how it exactly interacts with the EP interface for import and export of extra fields.

    1) Do I just upload this into the same EP upload field I would a normal EP upload?

    2) Do I have to create this raw file every time I want to upload or change any of these things?

    3) Does uploading this file one time allow me to export and manage these fields on future exports and imports?

     

    Thanks for the help.

     

    Rob


  5. The extra fields contribution has nothing to do with the Custom Fields settings for the products and products_description tables. If you have the extra fields contribution installed you need to look at the instructions in the docs for the extra fields contribution.

     

    You would use the Define Custom Fields area of the settings if you have added fields to the products or products_description tables only.

     

    i realize the two contributions are separate, but they do overlap.

     

    I now understand that where my data is stored does not help the process as only products and products_description tables are used.

     

    So my next question is what can I do to include other tables and the data within them? Is there a way to include them?

     

    Rob


  6. you say you are using 2.76h. But neither "product_size" nor "product_uom" are anywhere in that version. So you must have added it somewhere. I would suggest going back to the version I uploaded and starting over. Only change the setting you are sure you understand. If there is any settings I can clarify, ask first.

     

    Okay, so I looked in PHPmyAdmin to find where product_size and product_uom are located.

     

    They are declared in the table: products_extra_fields, where product_extra_fields_id is the unique index for the various extra fields.

     

    Then the values for this are stored in: products_to_products_extra_fields table where they ref the product_extra_fields_id.

     

    So for example size and uom are declared in products_extra_fields with product_extra_fields_id of 6 and 7 respectively. Then in table products_to_products_extra_fields is has products_id, product_extra_field_id (6 and 7 mentioned earlier) and product_extra_field_value where the values are stored.

     

    Now, All of that has my head spinning when I go through the instructions and get to this point:

     

    // BEGIN Define Custom Fields for your products database

     

    The instructions indicate that only works in tables products and products_description.

     

    Now I have ammended this and I am going to guess that this does nothing but create these as options to click on the export.

     

     $custom_fields[TABLE_PRODUCTS_DESCRIPTION] = array('product_size' => 'Products Size', 'product_uom' => 'U.O.M.' );

     

    So at that point I am lost. the instructions are leading me to believe that I cannot access that table and subsequently its date.

     

    So... please help... :-)


  7. and it won't like the product_uom either. did you add custom fields to the products table custom fields settings in EP ?

     

    Did you create those fields in the database also ?

     

     

    Okay not sure about the first one - add custom fields to the products table custom fields settings in EP? (Is this an oversight by me on the installation instructions?)

     

    The fields are in the database yes. Not in the products table, but another one for extra fields (This was the Extra Fields Contrib). Both of these show up in EP export check box in admin.

     

    Thanks

     

    Rob


  8. Okay, I got the model number issue sorted, but now when I try to upload, it produces this error:

     

    File uploaded.

    Temporary filename: /tmp/phpOnaAkw

    User filename: BABY revised 09-aug-01.csv

    Size: 6961

    | 188 | Active | LAVENDER L | | | | 10.99 | Gerber Updated

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

     

    UPDATE products_description SET products_name='LAVENDER LOTION', products_description='', product_size = '',product_uom = '', products_url='' WHERE products_id = '188' AND language_id = '1' LIMIT 1

     

    [TEP STOP]

     

     

    It would appear that it doesn't like product size? This is an extra field that we added same with product uom.

     

    Any ideas?

     

    Here are the full specs of my EP load:

     

    Settings & Info
    
    EP vers: 2.76h-MS2
    osCommerce Online Merchant v2.2 RC2a
    OS: Linux 2.6.28.9
    HTTP: Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.8i DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
    DB: MySQL 5.1.30
    PHP: 5.2.9 (Zend: 2.2.0)
    
    Temp Directory:
    /home/spogbz/public_html/temp/
    Temp Dir is Writable
    Magic Quotes is: off
    register_globals is: on
    Split files on: 3000 records
    Model Num Size: 12
    Price with tax: false
    Calc Precision: 2
    Replace quotes: false
    Field seperator: comma
    Excel safe output: true
    Preserve tab/cr/lf: false
    Category depth: 4
    Enable attributes: false
    SEF Froogle URLS: false
    More Pics: false
    Unknown Pics: false
    HTC: false
    SPPC: false
    Extra Fields: false

     

    Now again, I get the posted error when trying to upload and the only thing I can think of is that it doesn't like the product_size custom field.

     

    Any help?


  9. Okay, I got the model number issue sorted, but now when I try to upload, it produces this error:

     

    File uploaded.

    Temporary filename: /tmp/phpOnaAkw

    User filename: BABY revised 09-aug-01.csv

    Size: 6961

    | 188 | Active | LAVENDER L | | | | 10.99 | Gerber Updated

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

     

    UPDATE products_description SET products_name='LAVENDER LOTION', products_description='', product_size = '',product_uom = '', products_url='' WHERE products_id = '188' AND language_id = '1' LIMIT 1

     

    [TEP STOP]

     

     

    It would appear that it doesn't like product size? This is an extra field that we added same with product uom.

     

    Any ideas?


  10. All, could you please look at this thread here:

    http://forums.oscommerce.com/index.php?showtopic=341992

     

    I am trying to insert unique values into my product_model column so that EP will work properly. Is there a SQL query that I could use to do this quickly?

     

    Also, why does EP NOT extract the product ID number? You would think, since that is the unique value, it would be the one used to check products on import instead of the product_model. Seems like an oversight to me?

     

    Any ideas about this?


  11. GETTING AN ERROR INSTEAD OF SEARCH RESULTS.

     

    I have installed this contrib (an apparently easy process) on my site, www.spog.bz, but when I submit a search I get the following error:

     

    1066 - Not unique table/alias: 'pd'

     

    select count(distinct p.products_id) as total from (products p left join products_to_products_extra_fields p2pef on p.products_id=p2pef.products_id) left join manufacturers m on m.manufacturers_id=p.manufacturers_id, products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c, products_description pd, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%huggies%' or p.products_model like '%huggies%' or m.manufacturers_name like '%huggies%' or p2pef.products_extra_fields_value like '%huggies%' or pd.products_description like '%huggies%') )

     

    [TEP STOP]

     

    Now I don't know enough about PHP and MySQL to decipher this. My guess is that there is something it is looking for that it is not finding in the DB. however I am oblivious to how to determine what or where (aside from something 'pd') and how to fix it.

     

    any help would be greatly appreciated.

     

    Thanks

     

    Rob

     

    SIDE NOTE... It appears I am getting this error on any search submission, not just from this contribution. Any ideas?


  12. All,

     

    I have just installed the export orders to CSV contribution and though it works fine it does not provide the data in a very useful manner for my needs, nor does it grab some critical database info that I require (info added through the Extra Fields contribution).

     

    So my first question is: Is there another contribution out there that allows you to export all orders in a more organized and consolidated format? (Maybe select the fields you want to export)

     

    And if not is there any way to automate the organization of the CSV file into a format that does suit my needs?

     

    Thanks for the help.

     

    rob


  13. I am trying to implement the handling fee contribution (http://addons.oscommerce.com/info/1190) and the instructions are fairly simple, but when I install and configure in the admin, it does not display on the public end. I am not sure if this is due to the template I have used or if this is something else, but is there a way for me to go in and add the bit of code so this does display?

     

    Any help would be good thanks.


  14. Working, but a couple questions?

     

    All, Firstly, if this is posted elsewhere I apologize... this forum for some reason will not allow me to search for anything. So please don't chastize me!

     

    Okay, so I have installed it and I have downloaded and uploaded a sample file with no changes - no problem. I have downloaded, changed and uploaded the sample file and no problem... well no errors.

     

    So what I changed was I added the custom fields:

    $custom_fields[TABLE_PRODUCTS] = array( 'products_size' => 'Product Size', 'products_uom' => 'U.O.M.' );
    $custom_fields[TABLE_PRODUCTS_DESCRIPTION] = array( 'products_size' => 'Product Size', 'products_uom' => 'U.O.M.' );

     

    (Now I beleive this may be an error in itself, as looking at it I am guessing that it should only be added to the second and not the first. Confirm?)

     

    Now it uploaded it just fine, but (and maybe I am unclear on whether this is supposed to happen or not) I cannot see the fields in my add product form, nor can I see the fields in the product details on the front end. Again, I might be mistaken on the functionality of this. Am I missing or incorrectly assuming something here?

     

    here is the shortened, changed sample file: http://spog.bz/temp/shortened.csv

     

    Now the next question I have is that I want to upload extra fields that will be visible to the public in the product details and others that are to be invisible to the public, but included in the export of orders.

    The sample file of our current product spreadsheet is here: http://spog.bz/temp/sample_our_products.csv

    I have not changed the headers to match, but know how to do this. But the fields that I am concerned about hiding are:

    DISTRIBUTORS, SBT, PRODUCT CODE, CASE QTY and CASE PRICE.

    The feilds that I want visible are:

    SIZE and U.O.M.

     

    Is there a way to choose if they are hidden or shown (Again assuming here)?

     

    Also is there a way to hide the model number from being displayed on public end and to change the model numbering sequence to strictly numerical?

     

    Thanks for any help you can provide.


  15. All, Firstly, if this is posted elsewhere I apologize... this forum for some reason will not allow me to search for anything. So please don't chastize me!

     

    Okay, so I have installed it and I have downloaded and uploaded a sample file with no changes - no problem. I have downloaded, changed and uploaded the sample file and no problem... well no errors.

     

    So what I changed was I added the custom fields:

    $custom_fields[TABLE_PRODUCTS] = array( 'products_size' => 'Product Size', 'products_uom' => 'U.O.M.' );
    $custom_fields[TABLE_PRODUCTS_DESCRIPTION] = array( 'products_size' => 'Product Size', 'products_uom' => 'U.O.M.' );

     

    (Now I beleive this may be an error in itself, as looking at it I am guessing that it should only be added to the second and not the first. Confirm?)

     

    Now it uploaded it just fine, but (and maybe I am unclear on whether this is supposed to happen or not) I cannot see the fields in my add product form, nor can I see the fields in the product details on the front end. Again, I might be mistaken on the functionality of this. Am I missing or incorrectly assuming something here?

     

    here is the shortened, changed sample file: http://spog.bz/temp/shortened.csv

     

    Now the next question I have is that I want to upload extra fields that will be visible to the public in the product details and others that are to be invisible to the public, but included in the export of orders.

    The sample file of our current product spreadsheet is here: http://spog.bz/temp/sample_our_products.csv

    I have not changed the headers to match, but know how to do this. But the fields that I am concerned about hiding are:

    DISTRIBUTORS, SBT, PRODUCT CODE, CASE QTY and CASE PRICE.

    The feilds that I want visible are:

    SIZE and U.O.M.

     

    Is there a way to choose if they are hidden or shown (Again assuming here)?

     

    Also is there a way to hide the model number from being displayed on public end and to change the model numbering sequence to strictly numerical?

     

    Thanks for any help you can provide.


  16. SORRY ABOUT THE CONTENT...

     

    WARNING THIS SITE IS TO BE AN ADULT TOY SITE - CURRENTLY ONLY THE TEMPLATE IS QUESTIONABLE, BUT PRODUCTS WILL BE ADDED OVER THE NEXT DAY OR SO.

     

    IF THIS OFFENDS YOU OR IS AGAINST THE LAW IN YOUR LOCATION, PLEASE DO NOT VISIT THIS SITE.

     

    I will try to adjust that bit and see if it makes a difference...


  17. I am implementing a template from template monster into OSC and for the most part it has worked out pretty good. A little tedious, but good... however the product_info.php page is giving me some trouble.

     

    http://www.vaniteaseboutique.com/product_i...?products_id=27

     

    The product info box is wider than it should be and subsequently pushing the right column outside the page confines. I have fiddled with some of the css to fix it, but have not been able to solve it.

     

    if someone with a bit more OSC template experience could help me out that would be appreciated.

     

    Thanks


  18. There is no adding libssh2 .. curl has to be recompiled with libssh2 .. only your host can do that for you.. if they are unwilling.. I would suggest finding another host..

     

    unfortunately .. for SSL authentication.. libssh2 is mandatory.. no way around it apparently..

     

     

    Jesse

     

     

    So is there any other way around this libssh2? My host will only provide that if upgraded to SSL hosting plan.

     

    Thought there was someone who mentioned cURL redirect or something for one file on a secure server? Any enlightement on this approach?


  19. Probably not a surprising error to anyone, but while trying to use the shipping module in the admin, I am getting the following errors:

     

    Step 2. Error: Failed check in /home/suchgirl/public_html/shop/admin/includes/languages/english/ship_canadapost.php at line 9. This most likely means that Canada Post has changed their user interface. You need to update your Canada Post Automatic Shipping Labels module.

     

    Now after reviewing the previous threads, I noticed the cURL and Port issues so I check with my host (Hostgator) and this was their reply:

     

    Regarding cURL:

    CURL Information => libcurl/7.18.1 OpenSSL/0.9.8g zlib/1.2.1.2 libidn/0.5.6

     

    Regarding Port 30000:

    The port was not open on the server but I have opened it up.

     

    Now the one thing I noted from the posts was:

    I believe curl also has to be built with libssh

     

    cURL Information libcurl/7.18.0 OpenSSL/0.9.7a zlib/1.2.1.2 libssh2/0.18

     

    Could this be what is causing the problems?

     

    Any help would be appreciated.

     

    Thanks

×