Jump to content

djs

Members
  • Content count

    150
  • Joined

  • Last visited

1 Follower

Profile Information

  1. djs

    Automatically send data feed to Froogle

    The webserver doesn't have write permissions to the directory that the file is being stored in. You can either create a blank file, and set the appropriate permissions on that file, or, set the directory as required by your webserver so it can write to the directory. For security consideration, it is best to create the file and set permissions. To do this via a shell: touch gfg_product_feed.txt chmod o+w gfg_product_feed.txt (this depends on how your host has your webserver configured). Dan
  2. djs

    Automatically send data feed to Froogle

    The functionality for large stores was added to the code some time ago, so I don't think that's actually your problem. Also, 40,000 products should write out in a few seconds, definitely under a minute, on a decent server. If it's taking 5-10, something else is wrong. Since it's not writing the file, I assume you actually have a permissions problem, and that the webserver can't write to the folder that your trying to save the file to. Normally you get error messages when this happens though, but those might be suppressed. If it isn't a permissions or configuration issue (such as trying to write to an invalid folder) than I don't have many ideas. Dan
  3. djs

    RMA Returns error for 2.2 MS2

    In return_product.php, find the line that says: tep_redirect(tep_href_link(FILENAME_RETURN . '?action=sent&rma_value='. $rma_value . '&return_id=' . $ticket_id)); and change to: tep_redirect(tep_href_link(FILENAME_RETURN . urlencode('?action=sent&rma_value='. $rma_value . '&return_id=' . $ticket_id))); This will prevent the & in the url from getting converted to & which is what the problem is. If you take the url you used above, and simply change the 2 places it says & to just & (deleting amp;) you'll find it will work. This code change prevents this from happening. Dan
  4. djs

    QBI Quickbooks Import

    I hear ya... I would have thought it was simply a 'number' for the tax rate as well, which you would think would make Quickbooks easier to maintain, test, release. Apparently, there is a LOT more to it than that. I usually like the simple answer (tax is tax is tax) but being a realist, if this was true, then it would work, and politicians would be out of part of their job :) Dan
  5. djs

    QBI Quickbooks Import

    Hi gazzzzzza Just curious, what version quickbooks are you using? Given the tax rate, it appears to be an international version, which isn't supported by QBI (yet). Overall, the contribution works well, so it's usually finding the issues with any given setup, much more than the issue with QBI specifically. Dan
  6. djs

    QBI Quickbooks Import

    I'm not familiar with thestorezone build, but it sounds like it has the admin access mod installed. You probably need to go under your administrator tab / file access / catalog / store files, and provide permissions to the QBI files. Dan
  7. djs

    NOOB-USPS methods problem

    tep_cfg_select_option is in includes/functions/general.php If you've edited general.php recently, chances are, that's where your problem is coming from. The actual function itself is: function tep_cfg_select_option($select_array, $key_value, $key = '') { $string = ''; for ($i=0, $n=sizeof($select_array); $i<$n; $i++) { $name = ((tep_not_null($key)) ? 'configuration[' . $key . ']' : 'configuration_value'); $string .= '<br><input type="radio" name="' . $name . '" value="' . $select_array[$i] . '"'; if ($key_value == $select_array[$i]) $string .= ' CHECKED'; $string .= '> ' . $select_array[$i]; } return $string; } You should confirm that this code is in general.php, and if it is, and you haven't done other modifications, replace your general.php file with a known working one. There are a few other things that will cause this problem, but start there. Dan
  8. djs

    QBI Quickbooks Import

    I'm hoping you can help clarify the workflow with this, I missed something. I think your one the right track here with a problem many of us face in our stores. With inventory, you have to pretty much decide what is the 'master' inventory source, and then try to slave from that. In general, it makes sense for quickbooks to be the master, especially if your running sales from multiple sources. As you point out, the problem then is how do you keep any slave inventory db's in sync. With your method, do I understand correctly that your basically exporting an inventory list from quickbooks and importing it back to osC? If so, do you do a reverse product match through the product lookup table in QBI? Adam's contribution has been wonderful, and has saved us a lot of time (a few little hiccups unique to my store, but I'm working through those). This sounds like it might solve a big portion of the remaining problems. Dan P.S. If your wondering, the unique problems to my store are caused by some rounding errors due to selling fractions of things, like 1.5 yds of fabric. I thought I had this figured out (see several posts / several pages back) but I continue to find some edge cases that cause transaction out of balance problems. These errors are visible in osC, so it's not the QBI mod, it's simply rounding differences.
  9. djs

    QBI Quickbooks Import

    If the name and the model match, it does work, but if you want to see a list of unmatched products, these would show up as unmatched, even if they 'work' because of the match. The concept was a way to deal with these. Also, in my store, probably half match and half don't. This basically means I have to match them all, or else there simply isn't anyway to tell what is matched by the model/name match vs what simply isn't matched. Of course, it might be simpler to convince my wife that the part numbers should match (long reason why they don't). Dan
  10. djs

    QBI Quickbooks Import

    FEATURE REQUEST A feature that I'd very much like to see in the next version is the ability in product matching to display only unmatched products. This would allow you to work on only the products that still need to be matched, without having to hunt them down. It would also be helpful(?) if there was an option in the product dropdown list to remove the items that are already matched. When you have 100's to 1000's of products, it can become a pain to scroll down to a matching line item. If matched items are removed, it's likely to be the one on top, or at least, very close to it. Obviously, it has to be an option you can select on the match page, since some stores may match mulitple items to the same part number. Also, an 'Auto-Match' function would be very nice, where if the model number and name match, the items are automatically matched in the table. This would help with the 2 items above. (yeah, I just put the tm on that for the fun of it, until my lawyer says I can trademark the term :) Of course, if we have an sql guru watching this thread, it would also be nice to speed up the match queries for the product match page. Of course, the slowdown could be the population of the dropdown box..... While I'm wishing for the moon, it would be nice to have a product status icon in the product match page as well. Or the ability to match only active products (selectable to either active / all / unmatched) Dan
  11. djs

    QBI Quickbooks Import

    Yeah, I didn't realize how this was done until I looked at it yesterday. Does seem a bit odd way to store it, but it works. Rather than parsing for the ( and )'s, why not just parse for words? I only use USPS, so it was easy for me to set that up, I'm not sure if it gets more complicated if you have other shipping methods enabled. You could even pretty easily build an admin table that allowed a person to enter a parse term (such as Parcel in the case of USPS) and the shipvia term to export. Since the term will simply import into QB, whether it matches anything or not, it seems a bit simpler to me. You could then build a case statement that does a strpos($title, $term), determine if it exists, and if so, set $shipvia=$term, and exit. I haven't played with how the shipping terms get stored with other methods, but it seems hard to predict where the shipping method might be in all cases. Dan
  12. djs

    QBI Quickbooks Import

    Actually, I did more checking.... should never post late at night :) Paypal payments are coming in fine, but the invoice is not being marked paid. If I look at the customers register, it does in fact show both transactions (the credit and the debit) so that part is all working. Now what I'm trying to work out is why the invoice doesn't come in as paid. In the IIF file, there does not appear to be a variable for PAID (which according to the documentation is valid), but I tried adding that, and, without a lot of testing, it doesn't seem to work. I guess I need to play a bit more..... Just for the record, I import paypal payments as invoices, and using QB 2002. Everything else appears to be working fine now. Dan
  13. djs

    QBI Quickbooks Import

    Also, is it possible to get paypal payments to come in as paid? I set paypal up in Setup / Payment as paid online, but the transactions still come in unpaid. I haven't spent much time looking into this yet, so it's likely to be something simple, just looking for confirmation that it should work. Thanks! Dan
  14. djs

    QBI Quickbooks Import

    Hi Adam Tremendous work on this contribution. It's come a long ways in a short time. I just got around to doing the upgrade today to version 2.02 from 1.01. I've always had trouble getting the shipping methods to match. Okay, not the biggest deal, but it's actually becoming more important nowadays.... Looking into this a bit, in my orders_total table, I have shipping entries that look like: United States Postal Service (1 x 0.55lbs) (First-Class Mail (2 - 5 Days)): Looking at the code in qbi_functions, it looks like this will cause a problem, since it's parsing for the last '(' to find the shipping method, which in my case ends up returning a delivery time, not the method. I cheated to make this work for me, and just parsed $title for things like Priority, First Class, Parcel, etc, and did a direct set of $shipvia based on those. Unfortunately, not very portable for others....., but it solved my problem :) I'm just wondering if I'm misreading this, or if I should really change the string parse to strip off the days first, and then search for the method, so it becomes a bit more portable???? Dan
  15. djs

    QBI Quickbooks Import

    Adam I ran into the same problem, turns out there is a typo in the sql file that upgrades from version 1 to version 2. in the qbi_1-00_2-00.sql file, line 84 you have: DROP TABLE IF EXISTS qbi_disc; should be: DROP TABLE IF EXISTS qbi_ot_disc; It's actually dropping a table that was installed just a few lines above. Dan
×