Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

RMD27

Pioneers
  • Posts

    448
  • Joined

  • Last visited

  • Days Won

    1

Posts posted by RMD27

  1. On 4/2/2020 at 8:21 PM, domiosc said:

    I try a little more, I have another problem with model have dash, for example 3197080-32 some products no update

    For error No products_model field in record. This line was not imported or no import: you can solve open with notepad++ o similar change the codification to utf-8 without BOM if only utf-8 not is suficient.
    And for fields they not need "quotation marks"

    v_products_model,v_products_name_3,v_products_gtin,v_products_price,v_products_specials_price,v_products_quantity,EOREOR

    Hi,  I only use underscore "_" in the product_model field not "-"

  2. 11 hours ago, domiosc said:

    I change Price with tax: false to true but then only base price is with tax and special without tax, not is possible both with tax?

    Please I try several way but if use exported file with excel have problems to import, change data or characters...
    but if change directly from text work correctly, how manage the exported file? no is possible export & import in xls/xlsx format?

    Are there more compatible import and export modules with phoenix?

    Thanks

    About the tax. I cant think of a reason why you would want the prices with VAT. If the government changes the VAT rate you are going to redo all the prices? If prices are without tax you just need to change the sales tax number in the admin.

    About the characters. Libre Office deals with different encoding in CSV, MS EXCEL does not (in my experience). Basically edit the CSV file with Libre Office.

    If you want to do some advanced stuff with the spreadsheet, open CSV file in Libre and save as xls. Then open it in Excel. When you have finished, open the xls in Libre and save as CSV and then re-import.

  3. 17 hours ago, leatherdealer said:

    This guy's confusion is even worse here than in the german forums... Could any mod or admin please block him, to prevent him from confusing a lot more people ? 

    mcmannehan 

    he is absolutely correct about SEO URLs. i think most people find them helpful and so do search engines to some extent

    https://moz.com/learn/seo/url

    https://www.searchenginejournal.com/seo-friendly-url-structure-2/202790/

  4. Same here. I think there is some basic info needed, ie title, manufacturer, model number, category. He says he downloads a complete product though and re uploads it with just the model_number changed and no joy. Unusual.

     

    Jeff - Do you get the "New Product!" showing at the end of the product line after you do the upload? EP should give you a line by line summary of what you just uploaded

  5. 14 hours ago, JeffHoffman said:

    I spent a few hours reviewing this thread and I could not seem to find a solution for my issue.

    I am unable to upload new products with new model numbers.

    I can download files, modify them, and upload just fine. However if I download a file, strip all but 1 product out to keep it simple, then change the model number, when I try to upload it, it is saved in the temp directory fine (just like the others) but it will not insert it into the db. Nor do I get any errors in the box in the GUI. I have the /temp directory set to 777

    I do have a lot of additional columns in both my products and products_description tables. All of which are mapped correctly in the easypopulate.php file. and are included when I download.

    is there a way to determine where the code is failing? The fact that it will download and upload existing items makes it clear the configuration of the file is good.

    To confirm. You download a complete product ie with all columns. You change the model number only. Upload the product back to OSC with all columns and a duplicate product is not created?

  6. On 10/15/2014 at 8:40 PM, RMD27 said:

    In your php settings you have mb at the end of the number for upload size? if you just have a number without mb EP will say imported but it does nothing.

    Hi. I think you would have to speak to your hosting company.

    I have a VPS. In WHM, the setting is in

    "PHP INI Editor" 

    "upload_max_filesize"

    You could ask them to check the number has an "M" at the end eg 128M

    It probably does but I had a problem similar to yours and it was because I had 128. only

    Worth a shot

  7. The extract you show, the new product is different from the others. Sometime an  '  can cause issues.

    You are using a VPS? If so, check your settings for upload size. I think I had a problem like this before. The MB was specified as 128. I changed it to 128M and it solved the issue. For me at least

  8. geoffrey

     

    As a test i took two individual products and gave them each the same p.products_model, which when exported became v_products_model.  I then edited each of these two lines and imported these two lines back into the system.  It worked flawlessly.

     

    So, it appears that p.products_model does not need to be unique (which make more sense) but it does need to be populated in a system in order to use Easy Populate.  Do you know if there is a specific reason that this field was chosen to be required.  I am trying to decide of my best next course of action.  I see two options....

     

    1) Edit easy populate so that it does not require this field populated.  Not sure of scope of this project as I haven't looked at the code quite enough.

    2) Populate this field in my system with a garbage value and then change the product_info.php page so that it does not display the value on the page

     

    Do you agree that these are my options?

     

    thanks again for the help. 

    Spoma

     

    So many good reasons why you need the product_model field.

     

    You can put a garbage value in it if you want but I would put something meaningful.

     

    About using the same number twice. Only do this if you are happy with both products having the same title.

     

    You would only use the same product_model twice if you had the same product in two different categories. 

  9. I am also getting the errors on EP 2.9-231 - I uploaded 13 records  it said it uploaded the records without any issues. and then .... nothing.  no product is displayed. 

     

     

    EP vers: 2.9-231

    osCommerce Online Merchant v2.3

    OS: Array 

    HTTP: 

    DB: 

    PHP: Array (Zend: )

     

    Temp Directory:

    /home/webguy77/public_html/temp/

    Temp Dir is Writable

    Magic Quotes is: off

    register_globals is: off

    Split files on: 300 records

    Model Num Size: 15

    Price with tax: false

    Calc Precision: 2

    Replace quotes: false

    Field seperator: comma

    Excel safe output: true

    Preserve tab/cr/lf: false

    Category depth: 7

    Enable attributes: true

    SEF Froogle URLS: false

     

    Other Support:

    MVS Support: false

    Products Images: true

    qpbp: false

    Additional Images: false

    Additional Images: false

    More Pics: false

    UltraPics Pics: false

    HTC: false

    SPPC: false

    Extra Fields: false

    PDF Upload: false

    Master Products: false

    I would check your php settings, specifically upload size, it should have "mb" next to the number eg 20mb

  10. So I have been playing and tweaking my data file with no luck. Here is what I have done and I still cant get new items to load

     

    Created a export file (1 Item)

    Used a txt editor and copied the Item

    Updated the v_products_model to have the value

    Added value for v_categories_name_3_1

     

    In my export it has v_categories_name_1_1 v_categories_name_2_1

     

    The file then gets uploaded, but when i run import (Normal) it basically takes me to the easy populate screen and at the top has my file name information.

     

    If I export and just re-import it worked. I am not sure what else to check now specially since all I'm doing is replicating a item

    In your php settings you have mb at the end of the number for upload size? if you just have a number without mb EP will say imported but it does nothing.

×
×
  • Create New...