CODEWITHSUNDEEP
phpmysqlmagento
CodePlayer
CodePlayer

Reputation: 169

How to add products in Magento 1.7 using php scripts outside magento structure

I need to import products from "POS Winward" software to my magento store.After going through Import/Export products modules including MAGMI,Custom IMPORT/EXPORT i am unable to fulfill my purpose.

First of all is it feasible? If Yes,Can you tell me about the product data tables,images data tables,category data tables needed to update while importing products using CSV or XML?

Upvotes: 0

Views: 496

Answers (2)

user2300579
user2300579

Reputation:

POS Winward exports data in the XML format. Use an XML Parser and generate a csv as Magento acceptable format. MAGMI imports csv file to impoprt product.

Exactly, MAGMI itself a powerful tool for import Product Purposes.

Upvotes: 1

dweeves
dweeves

Reputation: 5605

I think you didn't investigate magmi enough.

  • Through datapump API, magmi can use PHP arrays as input for ingest , so you're free to fill them the way you want.
  • Magmi also has SQL Datasource to have input handled by a SQL request on a database
  • Of course, you could also use CSV to import

Then this is more a question of knowing how POS Winward data is accessible and then to fill up the good columns of your source in order to be compatible with magmi importable columns and also (and not the easiest part) , a way to match the product datamodel of your magento instance (since notions like product type configurable/simples/grouped and all needed attributes as well as necessary associations) may not exist in the POS Winward datamodel.

In that latter case, you need to define "semantical mapping" rules and apply them to convert one "Winward POS product" into a "Magento product"

There is no magic bullet, but magmi might be the right gun ;)

Upvotes: 2

Related Questions