Automatically list products from different stores

Asked

Viewed 256 times

0

I have a question in comparing prices of products from different stores, I have no idea which component to use or how to do this. The idea is to do something similar to Buscapé and Zoom (relate the same product in different stores), and , later use this relationship to calculate the product price average in the e-commerce market. I enter the product data (ID, Name, Value) of the stores in the database (SQL Server) but I have no idea how to relate them automatically.

I believe it is by string, however, there may be products with cognates but different names.

Example:

Smartphone Dual Chip Samsung Galaxy S4 Mini Duos Unlocked Black Android 4.2 3G/Wi-Fi 8MP 8GB camera

Samsung Galaxy S4 Active Unlocked Android Graffiti 4.2 4G/Wifi 8MP 16GB camera

Smartphone Samsung Galaxy S4 Zoom White Android 4.2 3G Unlocked - 16MP Camera Wi-Fi Camera GPS 8GB Memory

Is the only way to relate the same product from different stores manually? Or is there a component you can use to automate this function?

c# sql string

  • Most likely, if you have such a successful website, you can negotiate with the stores some API to update the data (after all, the interest is theirs). You can even do the parse of website pages, but have to be prepared for changes, and have an alert for when something changes. It’s definitely not good for almost every case. The path of the API is the clear path to it. Even, you can make the API on your side and make it available to the stores themselves if you have a good representative to convince them to use it (and a nice contract for them to publish the correct price).

1 answer

0


Depends on what kind of information the stores give you. There is some information that is unique from product to product, regardless of where you sell it.

This type of classification is very common when working with Supply chain, SKU usage, etc.

If you can get the barcode of each product, it is very likely that you will be able to relate one product to another from other stores and ensure that it will be the same product. I think this would be the easiest way to get it, but you have to make sure that the stores provide that information to you.

  • Rodrigo, I get the name and ID of the Product (SKU), but for each store is different . I would like to know how offer comparators relate products, such as econovia.com.br that uses "Scrape" pages to popular database. Really, it would help me a lot to find out how this relationship is made.

  • @Jeangustavoprates store owners can classify their products with their own code. But items sold to the final consumer use a universal barcode, which identifies the country of origin, the company name, model and a unique product of that model. this is the code that comes in the cereal box, in the TV box etc. It may be that the store API is sending you the internal and not this one. You can even search through Google.

  • @Jeangustavoprates I’ll give you an example.. The submarine has a JSON API that you can get the products and this returns a list of Skus. You can ask for each SKU and in them, you will get information from EAN. EAN and one of these international standards to identify a single product. With it, you can link EAN products like other stores without fear! https://api-marketplace.submarino.com.br/explorer/#! /v1/sku/getSku_get_1

  • Thank you, I’ll study!

Browser other questions tagged c# sql string

You are not signed in. Login or sign up in order to post.