Easify Forums

Forums -> Products & Stock Control

 Import/Export Product Info

Post Reply
Page 1 of 1 1
Posted by Adrian Bhagat

Import/Export Product Info

I have around 1600 products in my shop which are published to my WooCommerce website. I haven't yet added descriptions for the products but this is now an urgent necessity and a very formidable data entry exercise. My plan is to employ an offsite data entry person to research and enter the Product Info for each product.

I don't want to give the person direct access to Easify. So, my plan is to export my product database from Easify to a CSV file and get the data entry person to add XHTML to the Product Info column. Once that is done, I would import the file to Easify to update the Product Info (ie the XHTML description). However, although Product Info is exported, there doesn't seem to be a corresponding field to map it to when importing.

Is it not possible to import Product Info?

I am also concerned that the Product Info wouldn't import successfully from CSV as it would contain quote marks, commas, and other special characters. Is it likely to work?

Alternatively, is there any way to directly access the Easify database using a database tool or my own code?

Thanks for any help or advice.

Posted by Richard

Re: Import/Export Product Info

Hi Adrian,

The product importer doesn't support importing of product web info (HTML descriptions and images)…

However it would be possible to do this from your own code using the Easify API.

https://www.easify.co.uk/Store/Details/294

The Easify API is basically what we use to communicate from Easify Pro to the Easify Server so it supports the full range of functionality. The minimum sign up is 30 days so you don't need to commit to it long term if you only have a single data import to do.

What programming languages are you familiar with?


Regards - Richard (Easify Developer)

Posted by Adrian Bhagat

Re: Import/Export Product Info

Thanks, that sounds ideal. I think the API would help me do other stuff like automate my ordering and restocking,

I've mostly programmed in Visual C++ but I have used C#, PHP, JS and ASP.NET. I'm happy to struggle through a new language if necessary.

Is there any documentation for the API so I can see what I would need to do to get the import working?

Posted by Richard

Re: Import/Export Product Info

C#, ASP.Net or PHP would be fine to hook into the API with.

The API is based on the OData protocol and is a RESTful API. So it's easy to talk to it using standard HTTP verbs like GET/POST etc...

Here's an example of getting a list of products where the stock level equals 5:

https://MyEasifyServer:1234/Products?$filter=StockLevel%20eq%205

The API subscription provides you with a username and password you can use to authenticate with your Easify Server.

Our Easify WooCommerce plugin makes use of the Easify API and is open source. You can see the source code for it here to give you some examples of using PHP to talk to it. https://github.com/EasifyDev/easify-wc-plugin-v4.x. The file class-easify-generic-easify-server.php contains some examples of talking to an Easify Server via the API.

If you want to code an application that you would use in-house I would recommend C# and a WPF/WinForms desktop application. Easify is coded mainly in C# and I could email you some code samples if you need to access specific parts of the system.

The documentation for the API is mainly in the form of a downloadable metadata file that describes all the entities (tables) and functions you can access, this is generated by your own Easify Server when you log into it with a valid API Subscription.


Regards - Richard (Easify Developer)

Post Reply
Page 1 of 1 1

Easify Website V 5.0    © 2024 Easify Ltd ® All rights reserved.     Privacy Policy