Latest News: (loading..)

crumplezone

Members
  • Content count

    18
  • Joined

  • Last visited

  1. I give up on this. I can't even get it to accept a price whatever I enter. That's besides all the other errors I'm getting. I can get rid of the returns policy error by commenting it out, but I have no idea how to solve the others. Should be simple? Should just work? This looks like a great contribution, but I can't afford to spend any more time trying to get it to work. 21916711 : Return Policy input not applicable. The Return Policy field Refund in the input has been ignored. 21916711 : Price is not valid. Please enter a valid price for your item (e.g. GBP 0.99). 21916711 : The item specific Brand is missing. The item specific Brand is missing. Add Brand to this listing, enter a valid value and then try again. 21916711 : The EAN field is missing. The EAN field is missing. Please add EAN to the listing and try again.
  2. Does price have to be 4 figures with 2 decimal places (xxxx.xx)? I'll take a look when I have time later this week. Thanks for the help.
  3. That seems to work thanks. However I'm getting more errors now. 21916711 : Return Policy input not applicable. The Return Policy field Refund in the input has been ignored. 21916711 : Price is not valid. Please enter a valid price for your item (e.g. GBP 0.99). 21916711 : The item specific Brand is missing. The item specific Brand is missing. Add Brand to this listing, enter a valid value and then try again. 21916711 : The EAN field is missing. The EAN field is missing. Please add EAN to the listing and try again. Return policy has been defined correctly I think I have entered a price. I've tried 15, GBP 15 and GBP 15.00 GBP15 I want all items to be buy it now. There should be an option to set listing duration to GTC (good till cancelled) Brand - is that the same as Products Manufacturer? I have entered a value for that. EAN - eBay does not insist on entering an EAN (you can use not applicable). I do not have EAN for any products. This is in production mode (screenshots attached). In sandbox I only get the return policy error.
  4. Thanks. I'll try that and let you know if it works for me.
  5. I get the error when I click save when trying to list on ebay_list.php. It is the same in sandbox and production I have checked all the keys and repasted them in and created a new sandbox user making sure it was on ebay UK. Have tried changing keys.php using both UK and GB, but no change. Screen shots attached of my settings. Also of categories.php and ebay_list.php Clicking Add this product to ebay, takes me to ebay_list.php Does the categories.php page look right to you?
  6. According to the link it's GB which I've tried. I did Google it before. I wouldn't waste your time if I hadn't. http://developer.ebay.com/devzone/xml/docs/reference/ebay/types/countrycodetype.html Ignore the shipping problem. I don't think it's relevant. Am I right that site name in module settings is the same as Item.Country that the ebay API gets?
  7. When I try to list I get Input data for tag <Item.Country> is invalid or missing. Please check API documentation. I am trying list on ebay uk. I've tried it in sandbox and production. I have site ID set to 3 which is correct for ebay uk. I've tried every combination for site name - UK, GB, EBAY-UK, EBAY-GB with no change. I don't get that error when I set everything to US, but no shipping methods are available. Any help appreciated.
  8. Thanks for the reply. I've uploaded all the files to the correct locations. I think it's BS Gold I'm using.
  9. I've copied all the files over for the BS version, but there is no box available to install in modules/boxes. Any ideas?
  10. There are clearly some errors in the original contribution. I found I was also getting blank CSVs until I used the code from ecommunlimited above. However, I am trying to get it to export other fields. I am trying to get enough info into the CSV for it to work with Royal Mail Click & Drop, but I'm not 100% sure exactly what is needed yet. I tried uncommenting the fields below $csv_output .= "Product_Id".$delim; $csv_output .= "Product_Price".$delim; $csv_output .= "Number".$delim; $csv_output .= "Product".$delim; $csv_output .= "Attribute".$delim; $csv_output .= "Attribute_Value".$delim; But am just getting the headers on the CSV, but no data in the columns below. I have also tried to get the queries 9 section to work with no results. I notice that this section still uses mysql_fetch_array in two places instead of tep_db_fetch_array which has replaced it in the rest of the code. However, when I replace these in queries 9, I get 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 2 select products_options, products_options_values from orders_products_attributes where orders_id = 2 and orders_products_id = [TEP STOP] Here's the code for queries 9 //Get list of products ordered $orders_products = tep_db_query("select products_model, products_price, products_quantity, products_name, orders_products_id from orders_products where orders_id = " . $Orders_id); // While loop to list the item $countproducts = 0; $csv_output_item = ""; $csv_output_order = str_replace($csv_output_ordersbefore, "", $csv_output); while($row_orders_products = mysql_fetch_array($orders_products)) { // loop through orders // More than one product per order, new line if ($countproducts>0){ $csv_output .= "\n"; $csv_output .= $csv_output_order; $csv_output_item = ""; } $csv_output_item .= "," . "BEGIN_ITEM". "," ; $csv_output_item .= ","; $csv_output_item .= filter_text($row_orders_products[0]) . ";" ; $csv_output_item .= $row_orders_products[1] . ";" ; $csv_output_item .= $row_orders_products[2] . ";" ; $csv_output_item .= filter_text($row_orders_products[3]) . ";" ; $Products_id = $row_orders_products[4]; $orders_products_attributes = tep_db_query("select products_options, products_options_values from orders_products_attributes where orders_id = " . $Orders_id . " and orders_products_id = " . $Products_id); while($row_orders_products_attributes = mysql_fetch_array($orders_products_attributes)) { $csv_output_item .= filter_text($row_orders_products_attributes[0]) . "," ; $csv_output_item .= filter_text($row_orders_products_attributes[1]) . "," ; } $csv_output_item .= "END_ITEM"; $csv_output .= $csv_output_item; $countproducts += 1; } // end while loop for products Any help greatly appreciated.