Software automatically update price and availability from products

Question

0.00/5 (No votes)

See more:

Hi everyone,

I have an ecommerce website that export a CSV file with this columns:

- SKU
- Title
- Model
- Quantity
- Price

I want to create a software in C# that automatically update price and availability from my products.

I have several prices because I have some lists of my vendors.

I want to choose the best price from another CSV/TXT file, verify that availability is more than one and update it in my ecommerce CSV.

What can I do that ? Which is the best way to do this ?

Best Regards,

Nicola

Posted 21-Oct-15 21:41pm

Member 10558090

Updated 21-Oct-15 21:42pm

v2

Add a Solution

Comments

ZurdoDev 22-Oct-15 8:22am

That's a pretty vague question. What price are you updating? Is there a 2nd db somewhere?

Member 10558090 22-Oct-15 9:01am

I give you an example. I sell a notebook that is available from 4 of my suppliers , but each has different prices. I sell the notebook for 3 £.

My vendor sell it at:

1 supplier --> 1 £
2 supplier --> 5 £
3 supplier --> 4 £
4 supplier --> 2 £

I want to update it's price from 3 £ to 1 £ (1 supplier has the best price).

Have you understand now?

I want to know how I can do this with a C# application.

Thank you for your reply.

ZurdoDev 22-Oct-15 9:07am

If you have the CSV you can just import it into SQL and update from there. Or, you write a C# app that does the same thing.

Member 10558090 22-Oct-15 9:14am

Yes, ok. But, I have to compare 4 different file, in different formats. Some are TXT and some are CSV.

You have a few examples that I can recommend?

Maybe someone who has done something like this ?

CHill60 22-Oct-15 19:01pm

RyanDev gave you some good advice, import them into SQL and update from there

Maciej Los 25-Oct-15 11:05am

Based on these few lines of issue's description, we can't.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)