Jump to content
dev osCommerce
Forum
  • Checkout
  • Login
  • Contact Us
  • Get in touch

osCommerce

The e-commerce.

New Demo
Our Partners

CatDadRick

Archived
 View Profile  See their activity

  • Posts

    253

  • Joined

  • Last visited

 Content Type 

Posts posted by CatDadRick

    NEW! Complete Order Editing Tool!

    in General Add-Ons Support

    Posted

    I installed a very early version of this contribution several months ago and it worked OK. Today I upgraded to 1.60 and now I'm getting an error...

     

    1146 - Table 'shop.orders_ship_methods' doesn't exist

     

    select ship_method from orders_ship_methods

     

    [TEP STOP]

     

    I don't have table "orders_ship_method" in my database and I can't find any info in this contrib about that table. Where does it get created?

     

    Thanks,

    Rick Knight

    RMA Returns error for 2.2 MS2

    in General Add-Ons Support

    Posted

    Jacob,

     

    Compare the files in "Existing files affected..." with the same files on your OSC installation and make whatever changes are needed. MOST of the existing files don't need additional changes IF you allready have the RMA system installed but a couple of them do. Catalog/account_history_info.php for example does need some additional modification. After you've finished comparing and updating, copy all of the other files in the contrib over your existing RMA files and then run the SQL script. I had to remove the configuration values from table "configuration" that were added by previous RMA installations, also, I made sure that the field structure for "products_returned", "products_exchanged" and "products_exchanged_id" in table "orders_products" matched the structure in the SQL script.

     

    This worked quite well for me, YMMV.

     

    Good luck,

    Rick Knight

    RMA Returns error for 2.2 MS2

    in General Add-Ons Support

    Posted

    Justin,

     

    Tell us the truth now, you're really a whiz kid programmer from redmond, slumming about in the open source world right?

     

    Excellent job. This contribution is working perfectly for me now, although I will look for the problem Cathy described in the previous message.

     

    I have a very heavilly modded OSC/SEC site and I've been trying to get this to work for over a year now and, now it does. All the functions that didn't work with previous versions now work including refund as Gift Voucher, email notifications, etc. Great job, thank you.

     

    Rick Knight

    RMA Returns error for 2.2 MS2

    in General Add-Ons Support

    Posted

    Martinmacca,

     

    No, I don't have that problem, but I have seen a lot of posts about it. I think it was fixed some time ago by Sebastian (Doing). Search back in this thread for posts by Doing.

     

    When I complete an RMA request, I'm directed to a new window that shows the RMA number and has instructions for using it.

     

    Rick Knight

    RMA Returns error for 2.2 MS2

    in General Add-Ons Support

    Posted

    Looking at the code in catalog/admin/returns.php, tax should be added, but something is preventing it from working and in fact, it looks like there is a substantial chunk of code missing or just not working. In the returns screen, just below the line item in the return it looks like there should be a subtotal like in the catalog/admin/orders.php and this subtotal area would have the tax calculation

     

    OK, I think I found something. Now if I only knew what to do with it.

     

    In catlog/admin/returns.php at around line 649...

     

    <?php

        for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {

      echo '              <tr>' . "\n" .

              '                <td align="right" class="smallText">' . $order->totals[$i]['title'] . '</td>' . "\n" .

              '                <td align="right" class="smallText">' . $order->totals[$i]['text'] . '</td>' . "\n" .

              '              </tr>' . "\n";

        }

    ?>

     

    This code doesn't seem to be doing anything, but I think it should be printing a total for the return line item above it, including tax if applicable. Looking at catalog/admin/orders.php there is similar code that prints order total, extra charges, shipping, tax and total. It seems returns.php should behave similarly. Any ideas anyone?

     

    Thanks,

    Rick Knight

    RMA Returns error for 2.2 MS2

    in General Add-Ons Support

    Posted

    i had a similar problem with the tax not being added when returning a product.

    Try this:

    Catalog>return_product.php

    Find approx line 380

     

     

    echo '</td>' . "\n";

    echo '            <td class="main" align="right" valign="top">' . $currencies->format(($returned_products['final_price']+$returned_products['final_price']/100*17.5) * ($returned_products['products_quantity'])) . '</td>' . "\n" .

            '          </tr>' . "\n";

     

    Martinmacca,

     

    Thanks for the tip. That won't work well for me as I have to charge (and refund) tax only in California and that's only about 10% - 15% of my sales.

     

    Looking at the code in catalog/admin/returns.php, tax should be added, but something is preventing it from working and in fact, it looks like there is a substantial chunk of code missing or just not working. In the returns screen, just below the line item in the return it looks like there should be a subtotal like in the catalog/admin/orders.php and this subtotal area would have the tax calculation. Can someone with more php skills than me take a look at this? Sebastion?

     

    Thanks,

    Rick Knight

    RMA Returns error for 2.2 MS2

    in General Add-Ons Support

    Posted

    I don't know if anyone else has experienced this problem, but I'm hoping someone can help.

     

    Doing some more testing of this contrib, I've noticed that tax is not being added to the return total. In Returned Products there is a column for tax and it shows the correct rate, but the column is empty. I have the current version of this contrib installed in a test environment and also an older version installed in a live store and in neither installation is the tax added to the return amount.

     

    I also have a couple of other problems I can live with, but it would be nice if they can be fixed.

     

    First, the Gift Voucher number is not being sent to the customer, but is being created and inserted in the coupuns table.

     

    Second, the Gift Voucher Comments are not being sent to the customer and are not being save to any table (I think I can fix this one).

     

    Is anyone else having these problems? Can anyone offer a suggestion for fixing any or all of them?

     

    Thanks,

    Rick Knight

    RMA Returns error for 2.2 MS2

    in General Add-Ons Support

    Posted

    The coupons, coupon_email_track, gv_tracking tables are all updated and the coupon shows up in Gift Vouchers Sent, but the email sent to the customer does not show any voucher or coupon.

     

    Sebastian,

     

    I've done some more testing and still everything works except that the email that's sent to the customer. It not only doesn't include the gift voucher information, any comments I enter into the comments block in the admin window also don't show up. I tried the returns.php file from IceTheNet, it made no diferrence.

     

    Anyone have any idea what's wrong?

     

    Thanks again,

    Rick Knight

    Credit Class/Gift Vouchers/Discount Coupons 5.10

    in General Add-Ons Support

    Posted

    Strider,

     

    Thanks for reply.

     

    Linda's 'Shoppe Enhancement Controller' is OSC 2.2 MS2 with a bunch of contribs already installed, including Ian Wilson's CCGV.

     

    I compared the new files in CCGV-5.10c with the CCGV that I have and many of them were identical, so I decided to give it a shot. I backed up my store and then copied all of your new files over mine. I'm now looking at the modified OSC files to see if anything needs changing, but so far nothing does, and my shop works fine with CCGV-5.10c.

     

    Thanks,

    Rick Knight

    RMA Returns error for 2.2 MS2

    in General Add-Ons Support

    Posted

    There will be additional entries in ccgv's tables coupon and coupon_email_tack WHEN finishing an RMA (complete this return checkbox enabled) AND doing this refund with a voucher (refunded by gift voucher checkbox enabled).

     

    You will have this voucher sent by the RMA System on your CCGV adminscreen if you surf to ccgv's gv_sent.php page and there will be some data about this voucher ... if it was used (and by which ip adress - gv routines) or not ;-)

     

    Sebastian

     

    Doing,

     

    I've followed your instructions on page 16 of this thread re. CCGV and RMA, but I'm having a problem with it. My CCGV-5.10c works correctly and my RMA_returns_2.13 works correctly, but when I approve a refund via Gift Voucher and complete the refund, the Voucher is not sent to the customer. Everything else seems to work. The coupons, coupon_email_track, gv_tracking tables are all updated and the coupon shows up in Gift Vouchers Sent, but the email sent to the customer does not show any voucher or coupon. I am able to send Gift Vouchers and Coupons from admin without any problems.

     

    Any idea how I can fix this?

     

    Thanks,

    Rick Knight

    Credit Class/Gift Vouchers/Discount Coupons 5.10

    in General Add-Ons Support

    Posted

    I have a very early version of this contrib installed and it does seem to work fine, but I think I need to upgrade to v5.10 or newer in order to get a feature working in the RMA_return_2.3 contrib. I've downloaded both 5.10b and 5.10c and I've looked through the install instructions but in both versions, the Upgrade instructions have not been completed or included. Has anyone here upgraded this contribution? Can anyone provide instructions or maybe some pointers?

     

    I have Linda McGraths SEC_2.2MS2 version of osCommerce installed and it came with the CCGV contrib pre-installed.

     

    Thanks,

    Rick Knight

    Automatically send data feed to Froogle

    in General Support

    Posted

    Found a typo I think.

     

    "$strip_replace" at lines 251 and 252 in v143 (192 & 193 in v13737) should be "$_strip_replace". I don't see that this is doing much with my store but without the first underscore my httpd error log was getting two "undefined variable" error lines for each product in my catalog. My log files are big enough so anything I can do to minimize the file sizes and make them more readable is a plus.

     

    Any word on when the 1.5 version will be available?

     

    Thanks,

    Rick Knight

    Automatically send data feed to Froogle

    in General Support

    Posted

    Great contrib,

     

    I do have a problem though. My httpd logs are showing two errors for every row of data that froogle.php exports...

     

    PHP Notice: Undefined variable: strip_replace in /pathto/froogle.php on line 192

    PHP Notice: Undefined variable: strip_replace in /pathto/froogle.php on line 193

     

    The next line of the log shows a successful ftp port command and the feed file looks OK.

     

    Also, I'm running on Linux and had some problems with the ftp_connect function. I have PHP-4.3.4 which apparently has ftp support off by default, so I had to rebuild PHP with "--enable-ftp".

     

    Thanks for a great contrib,

    Rick Knight

    Automatically send data feed to Froogle

    in General Support

    Posted

    211655,

     

    Windows servers (and workstations) have AT. It works similar to cron. I haven't use it for some time but it is capable of running allmost any job at any time on just about any schedule you might want. Do a google on "at commands" and you should be able to find all you need to get it going.

     

    Good Luck.

    CatDadRick

×
×
  • Create New...