addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupshelp-with-circleimageimagesinstagramlinklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

DFW WordPress Group Message Board WordPress Q&A › Using MS Excel to Upload into Database

Using MS Excel to Upload into Database

Linda
Webolu
Fort Worth, TX
Post #: 5
For our product page information I wanted to create a spreadsheet that could be easily uploaded for getting the initial data into the site and then using the spreadsheet to maintain the data ongoing.

I was told that I can only use the spreadsheet on the initial upload. And uploading the data a second time in the spreadsheet would add the data again duplicating the information.

Is that true?

Rudy "Yankeerudy" ...
yankeerudy
Fort Worth, TX
Post #: 175
Pretty much, yes. Generally, Excel is a poor way to maintain a database; there are better ways to handle it. I notice you're in Fort Worth, as I am. I'd be happy to meet you at a Starbucks to find a better solution.
Matt C.
user 13749624
Arlington, TX
Post #: 8
What would be the purpose of maintaining the data in excel ongoing? Most e-commerce solutions can handle inventory and sales tracking, so why would you want to double-enter data?

If you also have a brick-and-mortar store and are trying to sync inventory between the physical and e-commerce stores, there are ways to do that, too.
A former member
Post #: 3
I agree with the previous poster. Using Excel to manage the data would not be recommended.
Powered by mvnForum

Our Sponsors

  • WPEngine

    Special coupon for Members. Attend the Meetup to learn more.

  • Develare

    Looking for WordPress designers & developers to make your website sing?

  • WP Attendant

    Headache-free WordPress maintenance plans. Free hosting included!

  • DFW Social Media Marketing

    Check out our monthly meetings.

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy