Script for StoreManager Data Import
Budget: €8 – €30 EUR
Hi, we require an SQL macro that we need to be able to delete EAN codes that have less than 8 numbers from the import.
So EAN codes that have between 1 and 7 digits must be removed from the import.
We use a software called StoreManager that uses SQL.
The formulas entered in the software look like this
IF([CSV_COL(16)]=0 OR[CSV_COL(16)]=‘’ OR[CSV_COL(16)]<0,‘’,[CSV_COL(16)])
Payment and/or Milestone after the problem has been solved.
So EAN codes that have between 1 and 7 digits must be removed from the import.
We use a software called StoreManager that uses SQL.
The formulas entered in the software look like this
IF([CSV_COL(16)]=0 OR[CSV_COL(16)]=‘’ OR[CSV_COL(16)]<0,‘’,[CSV_COL(16)])
Payment and/or Milestone after the problem has been solved.