Import Problems

Common problems with imports and how to solve them

Thousands of different files and pieces of data are uploaded to Plytix all the time. We've seen a lot of spreadsheets come through, so we've also noticed that there are common problems and errors when it comes to importing into our system. In this article, we will highlight some of the most common errors we encounter and how to fix them. 

 

Corrupted File

Funky Characters

Wrong File Settings

SKU Matching Issues

Other Problems

 


Corrupted File or Funky Characters

This means that something is off within the spreadsheet and it may not be visually apparent to you (sometimes they are literally invisible). This usually happens with text fields.

If this happens, it is likely that when you import your CSV and see this screen: 

 

empty-import-matching

This means our importer tried to read the file and failed. Sometimes this can be fixed by changing the Charset and the other file settings, but sometimes not. If your case is the latter try to do this: 

Solution 1: Re-Export

  1. Import your spreadsheet into another system like Google Sheets*
  2. Download your CSV in CSV format
  3. Try to upload again to our system

*Don't use Excel for this. It is notorious for corrupting files with formulas and formatting styles

Usually this works because these systems are simply better at reading and cleaning up all kinds of corrupted files. We just haven't been around as long. 

Also, this will tell you if your CSV is corrupted beyond repair. If those systems can't read it, then it is likely something else is going on. 

Solution 2: Remove Rich Text or long text fields 

This is mostly just to test and identify which columns are the ones messing up your import.

  1. Remove long text fields
  2. Try to import again
  3. If successful, review the text fields you removed for any characters or formatting issues that may have thrown things off

Solution 3: Re-Export in UTF-8

The most common and standard Charset is UTF-8.

For this reason it is probably the safest bet in terms of reading/parsing the majority of characters. Try to re-export your CSV using UTF-8 and import again.

 


Wrong File Settings

If you see that screen above, and you believe your data is not corrupted, check the file settings. 

Make sure your Charset has been properly matched. Our system tries to guess this the best it can, but there are times when it doesn't guess right. You can also check your delimiters and separators by checking the properties of your CSV file. 

Solution: Reconfigure File Settings

  1. In the file preview, it will give you options for delimiters and character sets, change these to the settings of your CSV file
  2. The correct file settings will show you a preview with data split correctly among columns

⚠️ Sometimes the preview may appear correct for some attributes, but not all. Please check your actual file settings to ensure you are importing data correctly.

 


My SKU is matched but the button is disabled

The reason this happens is because we allow you as a user to create an attribute called "SKU", but we need you to match a column to the SYSTEM attribute SKU. 

Solution: Match to the System Attribute

To do this, check your SKU column and click the red X that appears when you hover next to the attribute name. 

sku-import

Then select MATCH EXISTING

match-existing-sku 

Then search for SKU and choose the one in the System Attributes group

sys-sku

System Attributes are identifiable by the purple SYS that appears after you have selected it. The green ATT denotes a user-created attribute. 

system-att-sku

Once that is done, the IMPORT button should be re-enabled.

 


Other errors

If your import was successful, but certain things didn't appear, check your Import Logs. 

Learn more about Import Logs here.

 

ℹ️ If you cannot figure it out, reach out. Make sure to send over the CSV you are struggling with and we will see what we can do. 

 


 

What's Next

 

If you have any questions just click on the chat box in the bottom-right corner and we'll be happy to answer them...

 

and please let us know 👇