Looking at purchasing the software - but not sure if it would be okay for our project? Any help would be great....
www.dbsoftlab.com/etl-tools/visual-impor...sional/overview.html
What I need to do in Updating WEBSITE project:
Step 1:
FTP - Warehouse
secure – username
secure – password
Download – delimited tab.txt - file
Step 2:
(delimited tab.txt file.....Import.... Delete columns (unwanted columns), add formulas (combine columns, add text “symbols etc...” )
Add – “HaP” to the SKU number
Add – 3 columns + “size” then four column
(excel formula =CONCATENATE (A2,” – “, B2, “ – “, C2, “ Size: “, G2) )
Add – percentage markup + Roundup – figure... ( currently using Excel formula )
Delete – image URL column – * Reason : Ecommerce software uses a different logic...
Step 3:
(Import the data) to either overwrite (update) or create new product rows...
Only use two dbo’s per Main Database = dbo.Nop_Product & Nop_ProductVariant
Nop_ProductVariant = SKU, Stock levels, Price, Manufacturer Part Number, product info... etc...
Product = Description and Meta info...
Both use the Key = ProductID
Step 4: For weekends
All of the above steps 1-3 to be schedule for weekend up loads....of the Warehouse data.
Other Notes: 1: Orders sent to Warehouse
Have seen in the examples that this is possible....Send orders by email – but we also might need to schedule for XML data feed to our warehouse...
Other Notes: 2: XML Export – Shopping Channels
Also – looking at export data for Google Base (Shopping) and other shopping feeds – so will need to formula the data to fit their rules...etc... (*.XML or *.Txt)
Simon
