Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

stocklister

Members
  • Content count

    8
  • Joined

  • Last visited

1 Follower

Profile Information

  1. I've returned to looking at the format of our Easypopulate export, and would like to know if anyone has been down this route - how do you show a product under several categories? Currently, to list a product under several categories, it appears in the Easypopulate file several times over, each with their own v_products_model code. This results in several products on the web, in the New products list for example, or when returning search results. I know there is a multiple category contribution, but this requires the use of the web interface for adding each product. Is there a category contribution which allows a CSV to be uploaded? Thanks Matt
  2. I've seen a few other people looking for the same solution, to I thought I'd wake it back up. If anyone else needs the same, could you add a reply to this post. Using a CRON task to automatically run EasyPopulate imports Our stock files are uploaded, pre-split, by a stock control system we have developed. It'd be great if the site were to run the import silently, so you dont need to log in to admin and run the import x number of times. My attempts so far I have tried to get this working using a cron task to automatically run EasyPopulate every 10 mins, but only if a certain file has been uploaded. This means that we upload files stock1, stock2, stock3 and a file called Doimport. The cron task runs a script, the script will then execute a SHELL SCRIPT (subtly different to perl) 0,10,20,30,40,50 * * * * /usr/local/psa/home/vhosts/website.co.uk/cgi-bin/update 2>&1 >/dev/null update script file: #!/bin/sh [ -e /usr/local/psa/home/vhosts/website.co.uk/httpdocs/catalog/temp/Doimport ] || exit rm /usr/local/psa/home/vhosts/website.co.uk/httpdocs/catalog/temp/Doimport echo "<CONTENT-TYPE: text/html>" echo "" echo "<HTML><BODY><H1>DONE</H1>" for I in `ls /usr/local/psa/home/vhosts/website.co.uk/httpdocs/catalog/temp/osc*` do T=${I##*/} echo "$I $T" echo "<BR>" wget --output-document=- --timeout=300 --http-user=username --http-passwd=password http://www.website.co.uk/catalog/admin/easypopulate.php?localfile=$T&buttoninsert=INSERT_INTO_DB 2>&1 > /dev/null done echo "</BODY></HTML>" To paraphrase, for each file matching the name osc*, run the easypopulate script for the file. This operates only if the Doimport file exists. Doimport is then deleted, so the script doesn't run in another 10 mins. Importantly, wget allows us to 'log in' to admin Problem is, A ) the script will run the import for stock1, stock2 etc all at the same time, so the server gets tied up trying to do all the imports symultaneously, the site slows to a crawl and none of the imports happen. The error log eventually says 'giving up' for each file. B ) The user gets no feedback if imports fail. An email would be nice! Anyone else looking for similar functionality? If you could try the above and let me know if you have any successes, also record how many product lines were imported, how many split files you had etc. Also, anyone else after the same solution please register your interest! Thanks Matt Brown btw, I have posted the request on the EP V3 requests list at http://forums.oscommerce.com/index.php?showtopic=153115.
  3. stocklister

    Easy Populate Version 3

    Automatic Import once uploaded :thumbsup: Cron compatible import option :thumbsup: Email confirmation of import Our stock files are uploaded, pre-split, by a stock control system. It'd be great if the site were to run the import silently, so you dont need to log in to admin and run the import x number of times. My attempts so far I have tried to get this working using a cron task to automatically run EasyPopulate every 10 mins, but only of a file has been uploaded. This means that we upload files stock1, stock2, stock3 and DoImport. The cron task runs a script, the script will then execute (for each file) wget --output-document=- --timeout=300 --http-user=username --http-passwd=password http://www.server.com/catalog/admin/easypo...=INSERT_INTO_DB 2>&1 > /dev/null only if the Doimport file exists. Doimport is then deleted, so the script doesn't run in another 10 mins. (wget allows us to 'log in' to admin) Problem is, A ) the script will run the import for stock1, stock2 etc immediately, so the server gets tied up trying to do all the imports symultaneously, the site slows to a crawl and none of the imports happen. The error log eventually says 'giving up' for each file. B ) The user gets no feedback if imports fail. An email would be nice! Anyone else looking for similar functionality? MB
  4. stocklister

    QBI to include card number?

    I have answers to my own questions: I've modified the qbi_engine_orders.php file to add column headings \tCCARD\tEXP and added to $cust_data. $myrowo["cc_number"]."\t".$myrowo["cc_expires"]. I can then turn on the 'Delete Ccard number' option, so the database only contains card numbers for orders that aren't yet processed. sftp is more secure than ftp, in the same way as https is more secure than http. Using sftp will be safer, but also using the Split Card Email option will add another level to the security. MB
  5. stocklister

    QBI to include card number?

    Is there any way to add the card details to the iif file created by the QBI contribution? If anyone has added the card details to the QBI output, or could tell me which field it is stored in, I may be able to get a bit further. Thanks ## Another question: ## If I choose to split the number, the card number stored in the database is masked with XXXXXXXX, isn;t it. Does anyone know if the FTP download process is any more secure than email? (IE should the number still be masked if it's only being transmitted by ftp?) I guess the answer is that the card details should be as secure as possible. Thanks for looking! MB
  6. Ideally the QBI_Create could be re-written to create the file without asking for a button click. Any idea how? ## Techie bit: ## I would like to have the QuickBooks iif file created by running a script, rather than logging in and clicking the Create IIF button. I am creating a process that will upload stock (using EP) and download orders (using QBI) so the shop owner doesn't need to log in to Admin. The admin folder is passworded, so I cannot simply run the url that the button click would: www.bla.com/catalog/admin/qbi_create.php?qbimported=0&name=neworders&engine=orders&stage=process The solution would be to run this url from within a shell script using wget (so I'm told). The wget command will accept username and password to get past the admin password. However, the result is that the QBI_Create php page loads, but does not run the buttons's click. Anyone else after the same mod, or have a solution? Thanks for looking! MB
×