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. 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?
  4. 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. :)
  5. 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.
  6. 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.
  7. 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?
  8. 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?
  9. 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.
  10. 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.
  11. Rachael w.

    Automatically send data feed to Froogle

    Thank you! It's working properly now.
  12. 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?
  13. 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" .
  14. 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!
  15. 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.
  16. 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:
  17. 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.
  18. 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
  19. 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.
  20. 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.
  21. Rachael w.

    Automatically send data feed to Froogle

    Thank you Jack. I have concat in there and I am not sure where to put the substr. Here's my line: CONCAT(products_description.products_name ,' - ' ,categories_description.categories_name) AS name, I'm having so many issues and I cannot figure out why. 1. I have my identifier set to 0 but it's not coming through the feed as False. (its not in the feed at all). 2. My condition is set to 1 and the option is set to "Refurbished" however google is stating that the condition is missing from the feed. 3. I have weight set to 1 and the accepted methods set to lb. google error shows it is missing from the feed. 4. I have the google product category set to 1 and the option at 855. I'm getting a warning that this is not in the feed either. I have looked over this so long I cannot see why it's omitting just these things. Can you please help?
  22. Rachael w.

    Automatically send data feed to Froogle

    Can anyone offer some code to truncate the title name to 150 characters? I've gone over the limit on a few and would like to just truncate for the feed. Thank you in advance for your help.
  23. Rachael w.

    Header Tags SEO

    Yes I meant the meta description. I'll see if I can find a work around for it. Thanks
  24. Rachael w.

    Header Tags SEO

    I think I've missed something somewhere. My product description tags are showing the same thing as my title tag. Where to I set this to show the name of the product - category - then the actual description?
  25. Rachael w.

    Header Tags SEO

    I believe I was told here that we did not need header tags for our search results pages. I am having those pages index in google like this: Is there any way to at least have the page show something like " Page 1 - Search Results - Store Title" ? Also, is there a way to add the product number to the tags? I have pages with duplicate titles and need to add that product number so at least one thing in the tags is different. ( I know I shouldn't have duplicate titles, but that's just how it worked out)
×