Jump to content

Rachael w.

Members
  • Content count

    705
  • Joined

  • Last visited

Everything posted by Rachael w.

  1. Rachael w.

    Easier Attributes

    The page loads but it loads like this. And clicking the links brings up a url like this admin/easier_attributes.php#tabs-1 I'm using a highly modified 2.3 I think. PHP 7.
  2. Rachael w.

    Easier Attributes

    Doesn't seem like the ajax portion of the add on is working for me. Is there any advice on how to troubleshoot why ajax doesn't work?
  3. Any chance anyone knows of an add-on to run a full csv report of the stores inventory? I have more than one image but I could modify it if I had a sort of template to work with. I also have the in/out of stock add-on so it would be nice to pull that in too. And, to be able to change the category ID in the report so I can pull just by category rather than one huge csv. Something that had an output with this: Product ID | Product Name | Product UPC | Product Price | Product Description | Quantity | In/out Stock | Item Number | Weight | Category String | Image 1 | Image 2 | Image 3 | Thank you in advance for your assistance!
  4. Rachael w.

    Generate inventory report from osc2.3

    Sorry, I had surgery right after I posted. I can pull it directly from the database, but I maybe just lazy. I have over 300,000 products. I just wondered if there was something out there already that I didn't know about. When I am able to sit and look closer at this thread and my head is less fuzzy I'll see what I can do. Thank you all!
  5. Rachael w.

    Oscommerce websites for sale?

    I have a HEAVILY modified OSC 2.3 I'm ditching in a month or so. Still working, gathering tons of sales everyday. I'm consolidating my websites into one huge store so this one will be gone. Of course, it would just be code and an empty database if I let it go. I have it set up with authorize.net but of course you could do whatever. The domain stays with me so I can forward my current customers. It might be a nice start, but you will, of course have to tweak the code to your satisfaction. And since I don't know what you're selling, I don't know if it would even be a good fit.
  6. I have a very old, heavily modified osc site. Working perfectly fine for me but I need to upgrade the code(have some from 10 years ago!). I'm confused on all the releases. Do I want to do the 2.3.4.1 boot strap version or the 2.3.4.1 downloaded from the osc site? I have downloaded Responsive Oscommerce Master which has a zip date of 2/4/18. Is this the one I should start working with? Can I run this with php7? I believe my current sites code will not let me upgrade it from php5. My biggest fear is that I have a massive images folder. Is there something for BS which will organize that folder?
  7. I've tried the fixes mentioned here and I still can't get rid of the error: Number field should not be quoted: 'ecomm_totalvalue' When I try either of the fixes the page shows no tags. With the original code it's just the error. Anyone still working on this?
  8. Rachael w.

    Automatically send data feed to Froogle

    Have you created a separate thread for this? I'm still working migrating to the most recent version of oscommerce and I have the old version with a footer.php called on the pages. I can't seem to get this to work right. I'm not getting errors, I'm just not seeing anything google on the page. Thank you for your help. Please respond with a link to your thread so we don't highjack the merchant feed thread. :)
  9. Rachael w.

    Automatically send data feed to Froogle

    Thank you so much Jack! I apologize for returning so late to respond. Your code DID WORK (the first suggestion)! I appreciate your dedication.
  10. Rachael w.

    NEW! Complete Order Editing Tool!

    I finally figured it out! I turned on the error reporting in the application top. I had the old googlecheckout payment option. I had deleted the google checkout file which threw an error when it was trying to find it as a payment method.
  11. Rachael w.

    NEW! Complete Order Editing Tool!

    I have this same issue. Were you able to fix it? Do you remember how you did it?
  12. Rachael w.

    NEW! Complete Order Editing Tool!

    I had to update my server since on of my sites was getting hacked pretty regularly (not an osc site). Now the order editor is giving me problems. It seems to be ending the page right after the address information. The payment method column titles are there but nothing after it. I'm not getting any errors in my log so I'm not quite sure of the actual problem. Here is the part that starts with the payment information: 'payment_method' => tep_db_input(tep_db_prepare_input($_POST['update_info_payment_method'])), 'currency' => tep_db_input(tep_db_prepare_input($_POST['update_info_payment_currency'])), 'currency_value' => tep_db_input(tep_db_prepare_input($currency_value['value'])), 'cc_type' => tep_db_prepare_input($_POST['update_info_cc_type']), 'cc_owner' => tep_db_prepare_input($_POST['update_info_cc_owner']), 'cc_number' => tep_db_input(tep_db_prepare_input($_POST['update_info_cc_number'])), 'cc_expires' => tep_db_prepare_input($_POST['update_info_cc_expires']), 'last_modified' => 'now()'); tep_db_perform(TABLE_ORDERS, $sql_data_array, 'update', 'orders_id = \'' . tep_db_input($oID) . '\''); $order_updated = true; Any ideas on what I need to change here to get the rest of the page to load?
  13. Rachael w.

    Automatically send data feed to Froogle

    I have the most recent code: GoogleBase V 3.5. The only difference I see is the mysqli. Whether I have it as mysql or mysqli it still doesn't produce products.
  14. Rachael w.

    Automatically send data feed to Froogle

    I had to do some upgrades on my server, now using php 5.4. Not sure if this is the reason but my feed is not returning any products (0). The column headers are created but there are no products in the feed. I am not getting any errors either. Here is the page after running the script: Any help would be greatly appreciated. The file did work correctly prior to the php upgrade.
  15. Rachael w.

    Automatically send data feed to Froogle

    Thank you! It's working properly now.
  16. Rachael w.

    Automatically send data feed to Froogle

    I cannot seem to get the settings right for the column "Identifier exists" to show up with a "False" in each row. Any help on that one?
  17. Rachael w.

    Automatically send data feed to Froogle

    Any suggestions on how to truncate the name (title) length down to 150 characters? I found this when researching: Would this work to put somewhere around this? $output .= preg_replace($_strip_search, $_strip_replace, strip_tags( strtr($row->name, $_cleaner_array) ) ) . "\t" . preg_replace($_strip_search, $_strip_replace, strip_tags( strtr($row->description, $_cleaner_array) ) ) . "\t" .
  18. Rachael w.

    Automatically send data feed to Froogle

    Thank you Jack and Kru. I've enabled options. I now have these column headers: link title description price image_link id availability condition expiration_date google product category mpn product_type upc I think I have it working correctly now. My CSV file isn't showing headers but my txt is. No big deal at this point since google is accepting my feed in txt form. I changed the code on this line from "not supported" to "FALSE" as described here: https://support.google.com/merchants/answer/160161?hl=en $output .= "\t" . (isset($row->isbn) ? $row->isbn : (strlen(OPTIONS_ISBN) ? OPTIONS_ISBN : "FALSE")); I have some items that are just showing a blank space for the ISBN. I believe that's on my end and I'll look at each individually. I am also getting that same sqlite error but the feed seems to be going through fine. I'll look into this later. Thank you for your support Jack!
  19. Rachael w.

    Automatically send data feed to Froogle

    I'll post the options I've filled in later today. Thank you for checking it out Jack.
  20. Rachael w.

    Automatically send data feed to Froogle

    A ton of questions. I'll try to organize them here as best I can. My settings: define('OPTIONS_ENABLED', 0); define('OPTIONS_ENABLED_AGE_GROUP', 0); define('OPTIONS_ENABLED_ATTRIBUTES', 0); define('OPTIONS_ENABLED_BRAND', 0); //if set, see options for this setting below define('OPTIONS_ENABLED_CONDITION', 1); define('OPTIONS_ENABLED_CURRENCY', 0); define('OPTIONS_ENABLED_EXPIRATION', 1); define('OPTIONS_ENABLED_FEED_LANGUAGE', 0); define('OPTIONS_ENABLED_GTIN', 0); //if set, a database field named products_gtin must exist define('OPTIONS_ENABLED_GOOGLE_PRODUCT_CATEGORY', 1); //http://www.google.com/support/merchants/bin/answer.py?answer=160081 define('OPTIONS_ENABLED_GOOGLE_UTM', 0); define('OPTIONS_ENABLED_IDENTIFIER_EXISTS', 1); //set to 0 if required - https://support.google.com/merchants/answer/188494?hl=en define('OPTIONS_ENABLED_ISBN', 0); //if set, a database field named products_isbn must exist define('OPTIONS_ENABLED_LABEL', 0); define('OPTIONS_ENABLED_MADE_IN', 0); define('OPTIONS_ENABLED_MPN', 1); //if set, see options for this setting below define('OPTIONS_ENABLED_PRODUCT_MODEL', 0); //displays the product model define('OPTIONS_ENABLED_PRODUCT_TYPE', 1); define('OPTIONS_ENABLED_SHIPPING', 0); define('OPTIONS_ENABLED_INCLUDE_TAX', 0); //0 = no tax, 1 = uses google method, 2 = UK Vat define('OPTIONS_ENABLED_UPC', 1); //if set, a database field named products_upc must exist define('OPTIONS_ENABLED_WEIGHT', 0); The only column headers showing in the feed are: link title description price image_link id availability (these columns all contain the correct information) "products_upc" does exist in the table "products". Not all products have a upc so I would expect those to return false and the others to contain the upc. (no column or contents) Condition is not showing (no column or contents) Google Product Category is not showing (no column or contents) MPN (name) is not showing. (no column no contents) Identifier exists is not showing ( no column or contents but should all be false) I've attached an image of the errors in the google merchant center with all the errors. I also have this error when creating the feed:
  21. Rachael w.

    Remove Unused Images [Support Thread]

    I am not sure I found what I was looking for. Can anyone clarify this addon for me? I'd like it to scan the database for image names associated to products then scan my images folder to match those names. Any image in the images folder which does not match a product image will be removed. Is this what this addon does? Does it show a list of images which have no matches to the product images? Thanks in advance for your help.
  22. Rachael w.

    Automatically send data feed to Froogle

    In the past google has allowed us an exemption. I haven't been staying up to date on my feeds so I'm trying to get back into it. I was going by this line on the feed specifications. https://support.google.com/merchants/answer/188494?hl=en
  23. Rachael w.

    Automatically send data feed to Froogle

    I downloaded the most recent addon. I've used the google feeder file with the changes for my ftp information. I have edited the following: define('OPTIONS_ENABLED', 0); define('OPTIONS_ENABLED_AGE_RANGE', 0); define('OPTIONS_ENABLED_ATTRIBUTES', 0); define('OPTIONS_ENABLED_BRAND', 0); //if set, see options for this setting below define('OPTIONS_ENABLED_CONDITION', 1); define('OPTIONS_ENABLED_CURRENCY', 0); define('OPTIONS_ENABLED_EXPIRATION', 1); define('OPTIONS_ENABLED_FEED_LANGUAGE', 0); define('OPTIONS_ENABLED_GTIN', 0); define('OPTIONS_ENABLED_GOOGLE_PRODUCT_CATEGORY', 1); define('OPTIONS_ENABLED_GOOGLE_UTM', 0); define('OPTIONS_ENABLED_IDENTIFIER_EXISTS', 0); define('OPTIONS_ENABLED_ISBN', 0); define('OPTIONS_ENABLED_MADE_IN', 0); define('OPTIONS_ENABLED_MPN', 0); define('OPTIONS_ENABLED_PRODUCT_MODEL', 0); define('OPTIONS_ENABLED_PRODUCT_TYPE', 1); define('OPTIONS_ENABLED_SHIPPING', 0); define('OPTIONS_ENABLED_INCLUDE_TAX', 0); define('OPTIONS_ENABLED_UPC', 0); define('OPTIONS_ENABLED_WEIGHT', 1); define('OPTIONS_AGE_RANGE', '20-90 years'); define('OPTIONS_AVAILABILITY', 'quantity'); define('OPTIONS_BRAND', 'name'); define('OPTIONS_CONDITION', 'Refurbished'); define('OPTIONS_CURRENCY', 'USD'); define('OPTIONS_CURRENCY_THOUSANDS_POINT', ','); define('OPTIONS_DATE_FORMAT', 'Y-m-d'); define('OPTIONS_FEED_LANGUAGE', 'en'); define('OPTIONS_GOOGLE_UTM', '?utm_source=GoogleBase1&utm_medium=BaseFeed1&utm_campaign=products'); define('OPTIONS_GOOGLE_PRODUCT_CATEGORY', '855'); define('OPTIONS_GTIN', ''); define('OPTIONS_ISBN', ''); define('OPTIONS_MADE_IN', 'US'); define('OPTIONS_MPN', 'model'); define('OPTIONS_PRODUCT_TYPE', 'full'); define('OPTIONS_SHIPPING_STRING', 'US:FL:Ground:7.00'); define('OPTIONS_TAX_RATE' , '20.0'); define('OPTIONS_TAX_CALC', (OPTIONS_ENABLED_INCLUDE_TAX == 2 ? (OPTIONS_TAX_RATE/100) + 1 : '1')); define('OPTIONS_UPC', ''); define('OPTIONS_WEIGHT_ACCEPTED_METHODS', 'lb'); define('OPTIONS_IGNORE_PRODUCT_PRICE', 1); define('OPTIONS_IGNORE_PRODUCT_ZERO', 1); I sent the feed and when I view it the column headers and content only show this: link title description price image_link id availability Can you tell me what I'm doing wrong? I do not have upc/mpn/isbn, etc. So I need the column to show for Identifier exists with false in each row. I have a table rate for shipping which I've set up in google merchant.
  24. Rachael w.

    Automatically send data feed to Froogle

    I thought I had the latest feed. I must have downloaded the wrong one. I'll look again.
×