Announcement

Collapse
No announcement yet.

Import Issue

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Import Issue

    Must be something so basic I just can't see it.

    This is my import file
    PRODUCT_CODE PRODUCT_SKU PRODUCT_NAME CATEGORY_CODES PRICE COST TAXABLE ACTIVE PAGE_TITLE META_DESCRIPTION META_KEYWORDS WEIGHT PRODUCT_TYPE
    13-02-001 13-02-001 Blue Can Premium Drinking Water 50-year Shelf Life, 12 oz. food_water,mass_care_public_health,kits_school_sup plies,featured,water 39 0 0 1 Blue Can Premium Drinking Water 50-year Shelf Life, 12 oz. Blue Can Premium Drinking Water 50-year Shelf Life, 12 oz. 50 Year Shelf Life, Blue Canned Water, Water, Emergency Water, Emergency Manager, Emergency food 21 P
    Auto detect is on, comma seperated yea, yea, yea...but i get the dreaded "Product_Code must be assigned error". Saving from an Excel to UTF-8 comma deliminator.
    Bruce Golub
    Phosphor Media - "Your Success is our Business"

    Improve Your Customer Service | Get MORE Customers | Edit CSS/Javascript/HTML Easily | Make Your Site Faster | Get Indexed by Google | Free Modules | Follow Us on Facebook
    phosphormedia.com

    #2
    Hi Bruce - PhosphorMedia,

    Try saving it as "CSV (Comma Delimited)" from Excel and re-importing and it should work.

    The error you received is due to the UTF-8 CSV so I would recommend not using that option. It's really only needed when re-opening the CSV again in Excel. If you have data that includes unicode characters I would recommend maintaining the working file as an Excel Workbook (xlsx) then doing a save-as "CSV (Comma Delimited)" when ready to import. The unicode characters will be properly saved in the CSV if you view it in a text editor.

    Comment


      #3
      That worked...but what was odd is that the utf-8 CSV file(?) worked the first time. This was just an update (added a custom field)
      Bruce Golub
      Phosphor Media - "Your Success is our Business"

      Improve Your Customer Service | Get MORE Customers | Edit CSS/Javascript/HTML Easily | Make Your Site Faster | Get Indexed by Google | Free Modules | Follow Us on Facebook
      phosphormedia.com

      Comment

      Working...
      X