Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

devless

Archived
  • Posts

    44
  • Joined

  • Last visited

Posts posted by devless

  1. Hello,

     

    I have searched the contributions to no avail. Does anyone know of a contribution to export orders from Oscommerce to Australian versions of either Quickbooks or MYOB.

     

    Thanks

     

     

    The MYOB Export Module found at http://www.oscommerce.com/community/contri...all/search,myob

    will export your sales etc into MYOB

     

    The MYOB Items/Products Import found at http://www.oscommerce.com/community/contri...all/search,myob will export all your items/products into MYOB from your oscommerce website.

  2. Hi Jack,

     

    Yesterday I implemented version 2.0 of dynamic sitemap on my website. The installation went smooth, but i do have a problem I can't to seem to figure out. When I look at the sitemap page, there is no content, no threestructure of some sort. It displays nothing at all, just a blank page. When I look in my admin, all the functionalities appear, like adding and excluding categories, but like said before not at the front-end, at the sitemap. What could be wrong?? I have a heavily modified shop, based on STS and the language my shop is in Dutch. Could this be the problem or maybe something else. I hope you can help me out here... Thanks in advance!

     

    Rg.

    Dirk

     

    Hey Tracy,

     

    You're most likely getting this blank page because you are using STS. In order to correct this, please ensure that in /catalog/dynamic_sitemap.php you do NOT have the following code commented out. If you do, please remove the // from the start of the line below.

    <?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>

     

     

    Let us know if this fixes your problem

  3. Ok, here I am solving my own stupid problems again. I used my newly installed contribution "SQL Updater" to install Emmet's category and product SQL changes. Seems as though "SQL Updater" doesn't actually update the SQL at all :)

    So I manually did it, and "voila", category names "a la Emmet", thanks Emmet :)

    [small comment here: if I manually alter a category name, the subcategory urls do not reflect the new name - is this as expected?]

     

    So now comes the last problem which I just discovered, and it seems a couple of people on the forum have had it but there is no fix posted.

     

    When I enable SEO URLs in the Admin, my paypal_ipn capabilities break.

    If I disable SEO URLs in the Admin, my paypal_ipn works.

     

    Let me explain the situation:

    If I enable SEO URLs, a customer can make a purchase using paypal payment, and it can go through successfully and then the customer gets redirected back to my site. However - the customer and the admin order emails list an Invoice number of '0', plus in order history (both customer and admin) - NO order is listed - it doesn't get written to the DB.

     

    If I turn off SEO URLs, it all works as normal again.

     

    Is this anything to do with Session IDs?

     

    Any ideas?

     

    Here we go again! I fixed my paypal order problem by accident! So to those of you who may be experiencing the following issue, it's a very simple fix:

     

    PROBLEM:

    When you install and enable SEO URLs, customer orders via Paypal are no longer written into the database. The only inclination that you have been paid for an order, is the email from Paypal, advising you of the payment. Then you have to contact your customer to find out what they actually bought because there is no record of it :)

    When you disable SEO, Paypal orders are properly processed as normal.

     

    FIX: make "persistent connections" in your /catalog/includes/configure.php and /catalog/admin/includes/configure.php!!

    And in fact, by turning off persistent connections you are also providing a more secure environment for you shoppers and the admin backend (when on a shared hosted server).

     

    Chooch, you seem to be cluely on this contribution :), if SEO is not altering any backend urls or account urls, then how come this became a problem? - it's definately SEO that caused it.. (not that the fix was a bad thing anyway :) )

  4. Sorry, forgot to add to the above - my manufacturer pages ARE being written correctly. :)

     

    http://www.mysite.com/catalog/toyota-m-16.html

     

    Ok, here I am solving my own stupid problems again. I used my newly installed contribution "SQL Updater" to install Emmet's category and product SQL changes. Seems as though "SQL Updater" doesn't actually update the SQL at all :)

    So I manually did it, and "voila", category names "a la Emmet", thanks Emmet :)

    [small comment here: if I manually alter a category name, the subcategory urls do not reflect the new name - is this as expected?]

     

    So now comes the last problem which I just discovered, and it seems a couple of people on the forum have had it but there is no fix posted.

     

    When I enable SEO URLs in the Admin, my paypal_ipn capabilities break.

    If I disable SEO URLs in the Admin, my paypal_ipn works.

     

    Let me explain the situation:

    If I enable SEO URLs, a customer can make a purchase using paypal payment, and it can go through successfully and then the customer gets redirected back to my site. However - the customer and the admin order emails list an Invoice number of '0', plus in order history (both customer and admin) - NO order is listed - it doesn't get written to the DB.

     

    If I turn off SEO URLs, it all works as normal again.

     

    Is this anything to do with Session IDs?

     

    Any ideas?

  5. PM me your ftp details, Elise, and I will take a look for you.

     

    Cheers,

    Emmett

     

    Hey Yesudo,

     

    I managed to resolve most of my issues. My development server seems to be having mod-re-write problems (not to mention shortnames also being turned off).

     

    The initial problem of all the text code was the <? in the seo.class.php. My dev server didn't have shortnames turned on, so I simply changed the <? to <?php.

    Still have the mod-rewrite problem, but decided to upload to my production server (which I know has modrewrite working properly).

     

    So all seems ok, pages are working now. Chooch WAS right, an easy install (if your server is configured properly ;) )

     

    Last outstanding issue I have, is that all my product and category URLs are displaying as follows (without the category ascii-name):

    http://www.mysite.com/catalog/-p-276.html

    http://www.mysite.com/catalog/-c-22.html

    http://www.mysite.com/catalog/-c-22_63.html

     

    I've searched the forums but can't find the right answer - seems like a simple one to me - got any ideas?

    (all my SEO admin configurations are as defaults)

  6. Is there supposed to be some SQL inserted to enable the Administrative Side? (there was in Chemo's earlier URL contributions using the seo-install.php)

     

    What is the piece code that installs the admin?

     

    Ok, so following Chooch's comments that this is an easy install, I fully cleaned my store of SEO URLs and started again, using 2.1d by Emmett.

     

    And I'm back to my original problem.... I have installed the contribution VERY carefully. Of course this is no admin section yet, as this is built on the first successful pagecall - if only I could get this successful pagecall.

     

    I goto the index.php (and any other page), and it will display basically the contents of the /catalog/includes/class/seo.class.php (from line 68 to the end) - where it's trying to write to the database.

    And at the very bottom of this page of text code is the following error:

    Fatal error: Class 'SEO_URL' not found in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\catalog\includes\application_top.php on line 313

    Yet line 313 in my application_top has nothing related to SEO.

     

    Is this perhaps a DB problem instead?

     

    NB: using STS4.3 and HTC

     

    Thanks

  7. Hi there,

     

    I just installed Ultimate SEO URLs 2.1d (29Nov).

     

    When I attempt to access any page within my catalog the page will display with text code. The code displayed is verbatim from the /catalog/includes/class/seo.class.php (line 68 to the end).

    Also the bottom of the page has the following error:

    Fatal error: Class 'SEO_URL' not found in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\catalog\includes\application_top.php on line 313

    Yet line 313 in my application_top has nothing related to SEO.

     

    Another thing is that I do not have the SEO configuration link in my Admin. I have checked and rechecked the instructions, and have definately completed step 4 as advised in the guide.

     

    Please can someone help me out here before I have back out.

     

    NB: Not sure if this is relevant, however I have HTC2.6 and STS4.3 installed aswell.

     

    Thanks

     

    Ok, so I backed out of 2.1d (As I had tried and re-tried it many times).

     

    I've installed 2.1c instead, and at least it doesn't break my site, the pages still work correctly, but I STILL have no administrative interface to turn SEO URLs on??!!

     

    I'm obviously missing the administrative install somewhere - where is the code for the admin interface to configure SEO? (I must be blind)

  8. Hi there,

     

    I just installed Ultimate SEO URLs 2.1d (29Nov).

     

    When I attempt to access any page within my catalog the page will display with text code. The code displayed is verbatim from the /catalog/includes/class/seo.class.php (line 68 to the end).

    Also the bottom of the page has the following error:

    Fatal error: Class 'SEO_URL' not found in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\catalog\includes\application_top.php on line 313

    Yet line 313 in my application_top has nothing related to SEO.

     

    Another thing is that I do not have the SEO configuration link in my Admin. I have checked and rechecked the instructions, and have definately completed step 4 as advised in the guide.

     

    Please can someone help me out here before I have back out.

     

    NB: Not sure if this is relevant, however I have HTC2.6 and STS4.3 installed aswell.

     

    Thanks

  9. In sts_display_output.php change these lines:

     

    // This is required to prevent display of standard page elements (header, footer, etc) from the template and allow javascript code to run properly
    if (strpos($scriptname, "popup") !== false || strpos($scriptname, "info_shopping_cart") !== false) {
     $display_normal_output = 1;
     $display_template_output = 0;
    }

     

    to this:

    That should keep STS from using the template on the printorder file.

     

    - Brian

     

     

    Hi there, I have tried your suggestions regarding adding printorder to the 'normal' template list in sts_display_output, however unfortunately this creates the following error:

    Parse error: syntax error, unexpected T_BOOLEAN_OR in /home/xxxxxxx/public_html/catalog/includes/sts_display_output.php on line 40

     

     

    This is my changed code below.... where have I gone wrong?

    // Override if we need to show a pop-up window
    $scriptname = $_SERVER['PHP_SELF'];
    $scriptname = getenv('SCRIPT_NAME');
    $scriptbasename = substr($scriptname, strrpos($scriptname, '/') + 1);
    // If script name contains "popup" then turn off templates and display the normal output
    // This is required to prevent display of standard page elements (header, footer, etc) from the template and allow javascript code to run properly
    if (strpos($scriptname, "popup") !== false || strpos($scriptname, "info_shopping_cart") !== false)|| strpos($scriptname, "printorder.php") !== false)   {
    $display_normal_output = 1;
    $display_template_output = 0;
    }

  10. Elise,

     

    The first thing before trying your old template is to make STS4 working correctly using the "test" template folder.

     

    STS4 is much different than STS2, only the idea remains but the changes in osC files are so different that STS2 must be removed first, and then STS4 can be installed.

     

    So, I would propose these steps to upgrade:

     

    - Take STS2 from the contribution download page and check which files are modified by STS2

    - Remove the STS2 modifications (or replace by STS4 file if available)

    - Install STS4

    - When it works, try with your own template. If some placeholders are not working, check the doc. If you are using product info templates, check the doc for the compatibility mode available for old templates.

     

    That's more or less how I would do.

     

    - Rigadin

     

    Hey Rigadin,

     

    Thanks for your response. I already did exactly as you've advised. I completely removed STS2, and installed STS4.3.2 from scratch as a clean install. And THIS is the install I am unable to even get the test templates working - at all!?

     

    I've checked and rechecked my configuration/install and can't seem to find the culprit.

  11. Hey all,

     

    I've got a heavily modified site that I recently very easily converted to templating with STSv2.0 (yeah I know - sooo old) smile.gif

     

    I have built my desired templates and feel of the shop and have it working perfectly.

    But then I was lulled into the cool attributes of the newer STS4.3.2 version - admin control, on/off, various template modes etc..

     

    So, I decided to upgrade.... and now I can't get STS to work with my old designs. I can easily back out, but would rather have the newer version with all it's bells and whistles.

    It may be an upgrade incompatibility, or simply my inexperience with STS, but the core STS files seems to have fundamentally diffferent tags and coding in them. I've read the user and install guides, but still lost as to how to convert my old STS templates to be recognised byt he new STS system.

     

    With STS 4.3.2, whether I have STS Default turned on or off, my website doesn't change. Even if I specify for STS to use the /test directory with the test templates

     

    These are the upgrade/install steps I took:

     

    1. BACKED UP all my files smile.gif

    2. Replaced ALL the new files as mentioned for a FRESH install

    3. Copied my old sts_template.html to a new directory in \catalog\includes\sts_templates

    4. In ADMIN: turned ON STS DEFAULT, specified new directory

     

    That's it, and now I have the oscommerce header, footer, banner, column left and column right. Granted that I copied over my old column left/right, header and footer files, however STS2 template was not referring to these files anyway.

     

    Any help, muchly appreciated!!

  12. Hey all,

     

    I've got a heavily modified site that I recently very easily converted to templating with STSv2.0 (yeah I know - sooo old) :)

     

    I have built my desired templates and feel of the shop and have it working perfectly.

    But then I was lulled into the cool attributes of the newer STS4.3.2 version - admin control, on/off, various template modes etc..

     

    So, I decided to upgrade.... and now I can't get STS to work with my old designs. I can easily back out, but would rather have the newer version with all it's bells and whistles.

    It may be an upgrade incompatibility, or simply my inexperience with STS, but the core STS files seems to have fundamentally diffferent tags and coding in them. I've read the user and install guides, but still lost as to how to convert my old STS templates to be recognised byt he new STS system.

     

    With STS 4.3.2, whether I have STS Default turned on or off, my website doesn't change. Even if I specify for STS to use the /test directory with the test templates

     

    These are the upgrade/install steps I took:

     

    1. BACKED UP all my files :)

    2. Replaced ALL the new files as mentioned for a FRESH install

    3. Copied my old sts_template.html to a new directory in \catalog\includes\sts_templates

    4. In ADMIN: turned ON STS DEFAULT, specified new directory

     

    That's it, and now I have the oscommerce header, footer, banner, column left and column right. Granted that I copied over my old column left/right, header and footer files, however STS2 template was not referring to these files anyway.

     

    Any help, muchly appreciated!!

  13. Hey People!

     

    I've installed the Call for Pricing / Neogtiable Pricing and cannot for the LIFE of me find the support forum specifically for it.

     

    I have this contribution working in new_products, Specials and Product_info. However, I cannot seem to get it working for product_listing.

     

    I am using the column listing layout for product_info so the install instructions do not apply.

    So I'm sure that I have the right idea about what code to put where, but when I try to implement it, my entire page layout goes haywire!

     

    Below is the appropriate area to edit the /catalog/includes/modules/product_listing code:

    		if (PRODUCT_LIST_PRICE > 0) {
    	$lc_text .= '<td class="newprodimage3"> </td></td>
    </tr>
    <tr>
    	<td>
    		<img src="images/newprodimages_05.jpg" width="27" height="6" alt=""></td>
    	<td height="6" background="images/newprodimages_06.jpg"></td>
    	<td>
    		<img src="images/newprodimages_07.jpg" width="21" height="6" alt=""></td>
    </tr>
    <tr>
    	<td>
    		<img src="images/newprodimages_08.jpg" width="27" height="17" alt=""></td>
    	<td height="17" background="images/newprodimages_09.jpg" class="newprodprice">';
    	  if (tep_not_null($listing['specials_new_products_price'])) {
    		$lc_text .= '<s>' .  $currencies->display_price($listing['products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . '</s>  <span class="productSpecialPrice">' . $currencies->display_price($listing['specials_new_products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . '</span>';
    	  } else {
    		$lc_text .= ' ' . $currencies->display_price($listing['products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . ' ';
    	  }
    	  $lc_text .= '</td>
    	<td>
    		<img src="images/newprodimages_10.jpg" width="21" height="17" alt=""></td>
    </tr>
    </table>';

     

    And I would have assumed that below is how I would need to edit it:

    		if (PRODUCT_LIST_PRICE > 0) {
    	$lc_text .= '<td class="newprodimage3"> </td></td>
    </tr>
    <tr>
    	<td>
    		<img src="images/newprodimages_05.jpg" width="27" height="6" alt=""></td>
    	<td height="6" background="images/newprodimages_06.jpg"></td>
    	<td>
    		<img src="images/newprodimages_07.jpg" width="21" height="6" alt=""></td>
    </tr>
    <tr>
    	<td>
    		<img src="images/newprodimages_08.jpg" width="27" height="17" alt=""></td>
    	<td height="17" background="images/newprodimages_09.jpg" class="newprodprice">';
    	  if (tep_not_null($listing['specials_new_products_price'])) {
    		  $lc_text = ' <s>' .  $currencies->display_price($listing['products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . '</s>  <span class="productSpecialPrice">' . $currencies->display_price($listing['specials_new_products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . '</span> '; 
    [b][color=#FF6600]			} 
       elseif ($listing['products_price'] == 999999){ 
    		  $lc_text = TEXT_CALL_FOR_PRICE; 
    		} else { 
    		  $lc_text = ' ' . $currencies->display_price($listing['products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . ' '; 
    		} [/color][/b]
    	  $lc_text .= '</td>
    	<td>
    		<img src="images/newprodimages_10.jpg" width="21" height="17" alt=""></td>
    </tr>
    </table>';

     

    But that completely breaks my site layout as shown below:

    ORIGINAL ------> BROKEN

    Untitled-1.jpg

     

    Any Ideas??

  14. I am at a complete loss here, and I haven't found this in the forum yet (may have missed it, but I have been searching for a bit).

     

    I installed the dynamic_sitemap contrib and everything seems to be functioning fine except for the actual sitemap page that the visitor should see. It loads everything BUT the sitemap?? So I have my top, footer, left and right columns - just nothing in the middle :blink:

     

    I have no idea why there is nothing there, viewing the source code doesn't help me any - it just shows me where my sitemap should be located - but it is blank :

     

    <!-- start Default Content //-->

     

    <!-- end Default Content //-->

     

    That is exactly what my browser source code says for the area the sitemap should be in ???

     

    Anybody have any ideas as to what is happening?

     

    Tracy

     

    Hey Tracy,

     

    You're most likely getting this blank page because you are using STS. In order to correct this, please ensure that in /catalog/dynamic_sitemap.php you do NOT have the following code commented out. If you do, please remove the // from the start of the line below.

    <?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>

     

    Let us know if this fixes your problem

  15. Nope, that's not it.

     

    Just in case others on this forum are looking for the answer to this simple problem (kicking myself :).

     

    If you have the same errors as below:

    Warning: file(/catalog/includes/languages/english/header_tags.php): failed to open stream: No such file or directory in /home/xxxxxx/public_html/catalog/admin/header_tags_controller.php on line 280

     

    And the files ARE in fact located in the above directories, then you have incorrectly setup your /catalog/admin/includes/configure.php file.... DOH!!

  16. Hi there, I've installed HeaderTags 2.6 on my testsite (and have a previous version working on my live site).

     

    The only difference between the two sites is STS, but I have ironed out all those interop issues already.

     

    On my testmachine (winXP, Apache): headertags in admin produces the followign errors:

    Error Permissions settings for the C:/Program Files/Apache Software Foundation/Apache2.2/htdocs/gearshop/includes/header_tags.php file appear to be incorrect
    Error Permissions settings for the C:/Program Files/Apache Software Foundation/Apache2.2/htdocs/gearshop/includes/languages/english/header_tags.php file appear to be incorrect

    However I have already set both these files to Grant All Access - but then, you know how flaky windows chmod is! :)

     

    So I decided to upload the site to my live Unix webserver and use CHMOD777 on those files.

    So now, when I go to headertags in admin, I get the following error above each of the HT admin pages:

    Warning: file(/catalog/includes/languages/english/header_tags.php): failed to open stream: No such file or directory in /home/xxxxxx/public_html/catalog/admin/header_tags_controller.php on line 280

    Yet there IS such a file in that directory.... any ideas?

  17. Does the 'C' not indicate that it is searching for the command on your PC? Looks like you are using a server software on your PC rather than uploading files to a real sever.

     

    Hi Chooch,

     

    I AM running this on my staging server which is indeed a local Windows Apache Server, I don't see how this would be my issue?

  18. I've loaded the latest order editing tool, however when I try to edit an order I get the following error

    Parse error: parse error, unexpected $end in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\shop\admin\edit_orders.php on line 2307

     

    Has anyone found the open bracket?

     

    I've tried all the edit_orders.php files from all the contributions 2.8 and above

     

    (I can get the non-AJAX version 2.7.4 working just fine)

  19. Newsdesk usage options:

     

    Hi all. I really love the newsdesk contribution and have integrated into my website. I use my own page layout with the newsdesk code inserted into it.

     

    Currently with my own implementation, I can only put files into the TOP directory (due to the way that I am delivering content within my page).

    How can I have multiple news pages that only do an article listing of a specific directory.

     

    ie.. NewsPage1 essentially looks like PAGE_LISTING for TOP directory

    ie.. NewsPage2 would look like PAGE_LISTING for CATEGORY 2 etc.

     

    So currently I only have one NewsPage that calls the PAGE_LISTING MODULE, and I only have the artciles in the top directory.

     

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

     

    Also, what/where is the easiest way to add fields into the news input and display? I've managed to add the SQL entries, and have them display correctly on the frontend, but seem to have butchered my newsdesk_general.php in trying to get the admin to work.

     

    Any help is appreciated.

×
×
  • Create New...